Macro in Workbook problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a document that when I open it I get the Document May contain Macros window. Well when I look into this document under Tools, Macros, it doesn't show any macros. It's a pain every time I open this document to hit the disable macros button. Please help this go away! Thanks!
 
Hi
you also have to remove the (empty) modules:
- open your workbook
- open the VBA editor with ALT+F11
- remove the modules
- also check if there's some code in the worksheet modules and/or the
workbook module. Delete this code
- close the VBA editor
- save the workbook
- Try again
 

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