Deleting Macros from a Worksheet

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

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
 
Kevin,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Macros From a Worksheet 2
write vba to a worksheet via a macro 3
Excel 2003 - VBA to get a list of Module names in the project 4
How to call Excel add-in macro from a button… 1
Notify user macros are disabled. 3
Macro to delete blank rows in a worksheet 2
Why show Enable/Disable macro prompt after I deleted all macros? 1
Lose macros before saving 4

Back
Top