ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to stop file open macro prompt after deleting all macros? (https://www.excelbanter.com/excel-worksheet-functions/57777-how-stop-file-open-macro-prompt-after-deleting-all-macros.html)

twor57

How to stop file open macro prompt after deleting all macros?
 
Once you delete all macros, how do you stop the macro prompt during file open?

Paul B

How to stop file open macro prompt after deleting all macros?
 
twor57, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"twor57" wrote in message
...
Once you delete all macros, how do you stop the macro prompt during file
open?




Gary''s Student

How to stop file open macro prompt after deleting all macros?
 
Delete the modules as well as the macros
--
Gary''s Student


"twor57" wrote:

Once you delete all macros, how do you stop the macro prompt during file open?



All times are GMT +1. The time now is 10:37 AM.

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