Sometimes one might like to submit a spreadsheet somewhere for some help or support or whatever.
Often spreadsheets contain sensitive info, normally the main part of that is the text.
So great news then than Codematic today announces the release of a little workbook with a bit of VBA in that will enable you to remove or replace all that sensitive text.
Its only been very basically tested, so if you come up with any issues please let me know.
If you would like to use it to help Microsoft in their quest for poor performing VBA in 2007 then please do.
It doesn’t do names, or styles or anything clever, just text. The code is unprotected, if you come up with an enhancement please leave the code as a comment.
Please let us know how you get on
Cheers
Simon
Smurf on Spreadsheets 
Wednesday, 21st January, 2009 at 2:07 pm |
Hi Simon
There’s a typo on the page: It’s ‘intact’ not ‘in tact’.
Rob
Friday, 23rd January, 2009 at 4:40 pm |
Just an additional idea. This thread
http://www.dailydoseofexcel.com/archives/2006/07/12/probabilistic-lookup/
encouraged me to make a random name generator, using VLOOKUP for a random number in a sorted list of weighed popularity numbers and corresponding names. It has been very useful when I need to mask real world data for class examples. Or just generate a long good looking list of nonsense.
Best wishes Harald