View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Deleting Macros from a Worksheet

Kevin,

You need to remove the module in which the macro resided. An
empty module will cause the macro warning to appear.



"Kevin Sprinkel" wrote in
message ...
We have a company standard of adding macros only to a
startup PERSONAL worksheet, and leaving them out of our
work product that goes to our client. Yesterday, I forgot
and created one.

Although I deleted it, I still get the Disable/Enable
Macros dialog on opening it. Does anyone know how I can
eliminate this message?

TIA
Kevin Sprinkel