Enable/Disable Macros

B

Ben Schaum

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.
 
P

Paul B

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
 
Top