macros

  • Thread starter Thread starter LH
  • Start date Start date
L

LH

Why do I get a message asking to disable macros when I
open a file that has no macros??
 
LH

Probably because your file used to have macros. You need to delete the
modules that held the macros as well as the macros themselves.

Andy.
 
Hi
probably the modules are still in your workbook.
Try the following
- open the VBA editor (ALT+F11)
- delete the (empty) modules from the explorer tree
- close the VBA editor and save the workbook

Try again
 
And don't forget to clear any lines of code from Sheet Modules and
ThisWorkbook module. Double-click on these to open.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Disable Macro Alert 2
Macro help 8
Macros in Excel2007 5
Run Macro If Cell have "x" value 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
EXCEL 2007 Macro Security Being Ignored 9
Excel Macro Warning problems 1
Macro deletion 1

Back
Top