View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Macro that won't go away!

In VBE (Alt+F11) , remove any "Modules" as they will invoke the message even
if there is no code.

"Michael Stroud" wrote:

I have a user that has created a macro for a particular spreadsheet that she
uses. After deciding she no longer needed the macro, she removed it from the
source document and saved the changes. However, attempts at re-opening the
file after removing the macro prompt the user to constantly enable/disable
macros, though there is no macro in the work, and the source document did not
do this before the macro was created and introduced.