L LH Mar 3, 2004 #1 Why do I get a message asking to disable macros when I open a file that has no macros??
A Andy B Mar 3, 2004 #2 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.
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 Mar 3, 2004 #3 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
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 Mar 3, 2004 #4 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
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
