View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR[_2_] CLR[_2_] is offline
external usenet poster
 
Posts: 28
Default Code to delete Macros

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