Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enable/Disable Macros
I have deleted all of the macros I created in my worksheet and saved the
worksheet. When I open the worksheet again, it still asks me if I want to enable or disable my macros. How do I stop receiving this message for my spreadsheets? It is particularly annoying because I am using this spreadsheet as a template, so I get the macro question in all of my related spreadsheets. |
#2
|
|||
|
|||
Ben,
You also have to remove the modules in 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 "Ben Schaum" <Ben wrote in message ... I have deleted all of the macros I created in my worksheet and saved the worksheet. When I open the worksheet again, it still asks me if I want to enable or disable my macros. How do I stop receiving this message for my spreadsheets? It is particularly annoying because I am using this spreadsheet as a template, so I get the macro question in all of my related spreadsheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros making file saving extremely slow. | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
How do I stop Excel from prompting to enable or disable macros? | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |