MrExcel Publishing
Your One Stop for Excel Tips & Solutions

disable macros


Posted by Rick Alford on January 18, 2001 8:32 PM

How do I remove the information on a worksheet that asks the user to enable or disable a macro when the worksheet does not have a macro within it? I did have a macro that I was using then deleted it after I was finished using it as it was just a utility macro while I was building the sheet. Now when the spreadsheet is opened it prompts the user that the sheet contains a macro and do they want to enable or disable it. I go into the macro menu and there are no macros. I know I can disable it on my Excel setup options however the other users may not want to and it is anouying since no macro exists.

Thanks for any help


Posted by Loren on January 19, 2001 4:39 AM


Alt-F11 for vba editor. There will be a module there.
It remains after you delete a macro. Delete the
module.

Posted by Rick Alford on January 19, 2001 10:43 AM

Thanks for the tip Loren, it worked great!