macros

L

LH

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

Andy B

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.
 
F

Frank Kabel

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
 
G

Gord Dibben

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
 
Top