http://www.cpearson.com/excel/vbe.htm

but why not protect the code in the VBE?

If you do, then you won't be able to delete it, but that form of protection
is fairly robust for the average user.

----------
I guess the scenario is not clear. You are giving the book complete to the
user, then the code will delete code after a demo?

--
Regards,
Tom Ogilvy

"CLR" wrote in message
...
Hi All.........

I must provide a worksheet to a Customer for their perusal. There are
several Macros involved that I do not want them to see. What is the code
please for me to write a "Sanitize" macro that will delete all macros from
the modules, workbook, etc that the Customer need not see ? I tried
recording it, to delete individual macros by name, but that part does not
show up........

TIA
Chuck, CABGx3