it should solve my problem.

For your consideration (posted by Stephen Bullen)

Generally when automating the IDE, it's not a good idea to modify your own
project. What are you trying to achieve?

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
Thanks Bob.........

A lot more there than I had sense enough to ask for, but from a cursory
look, it should solve my problem.

Vaya con Dios,
Chuck, CABGx3



"Bob Phillips" wrote in message
...
Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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