Anon-i-mouse

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.

Full details here

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

Advertisements

2 Responses to “Anon-i-mouse”

  1. Rob Bruce Says:

    Hi Simon

    There’s a typo on the page: It’s ‘intact’ not ‘in tact’.

    Rob

  2. Harald Staff Says:

    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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: