View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
charles charles is offline
external usenet poster
 
Posts: 124
Default Macro code to remove a macro after it executes

After I run a macro to format an Excel worksheet, I would like to be able to
permanently remove all the macro code so that when a new user is sent the
formatted Excel worksheet, there is no pop-up window warning about Macros and
there are no Macros within the macro window.

What would be the code to have a macro permanently erase itself, without at
trace, from an Excel worksheet