Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ben Schaum
 
Posts: n/a
Default 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   Report Post  
Paul B
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros making file saving extremely slow. Donald Speirs Excel Discussion (Misc queries) 1 January 20th 05 10:10 PM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM
How do I stop Excel from prompting to enable or disable macros? ARSmythe Excel Discussion (Misc queries) 4 January 12th 05 01:07 PM
The available macros list in XL; how to suppress filename from showing KR Excel Discussion (Misc queries) 1 January 10th 05 07:20 PM
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 12:25 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"