ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro that won't go away! (https://www.excelbanter.com/excel-discussion-misc-queries/154480-re-macro-wont-go-away.html)

Toppers

Macro that won't go away!
 
In VBE (Alt+F11) , remove any "Modules" as they will invoke the message even
if there is no code.

"Michael Stroud" wrote:

I have a user that has created a macro for a particular spreadsheet that she
uses. After deciding she no longer needed the macro, she removed it from the
source document and saved the changes. However, attempts at re-opening the
file after removing the macro prompt the user to constantly enable/disable
macros, though there is no macro in the work, and the source document did not
do this before the macro was created and introduced.



All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com