Annoying Macro Message

  • Thread starter Thread starter JohnG
  • Start date Start date
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?
 
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
 

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

Back
Top