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