disabling macros question

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

Hi,

I am using an excel spreadsheet 2000 (9.0.2220). Whenever I bring up
my spreadsheet a warnig box appears telling me that the spreadsheet
contains macros and gives me a choice to disable them, or enable. I
have deleted all the macros in this particular document but the
message still appears whenever I bring up my document. Why would the
Excel program think that my document contains macros - and force a
warning upon me - when all macros have been deleted.

Thanks,

Sally
 
Hi Sally
you also have to delete the (empty) modules. Try the following:
- open the VBA editor (ALT+F11)
- delete/remove all modules from your file
- also check the worksheet modules and the workbook module for code
- close the VBA editor
- save the workbook

Now try again
 
Back
Top