Annoying Macro Message

J

JohnG

In trying to explain to someone how macros work I opened
up one of my files and did:
Tools - Macro - Record New Macro - OK

I immediately stopped the recording and deleted the macro
as the demo was complete. I continued working with the
file and saved it.
Now when I open the file I get a window asking if I want
to Enable or Disable the macro even though there are no
macros in the file. How can I stop the file thinking it
has a macro?
 
S

Steve Yandl

Alt plus F11 to get the VB editor. In the upper left window (project
window), navigate to the now empty module. Right click the module and
delete. The warning comes up because of the module, even if the only macro
it was created to contain is deleted.

Steve
 
Top