Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro Prompt

Status
Not open for further replies.
Jul 14, 2003
116
CA
When I originally started a workbook I created a macro. My manager then became annoyed with the prompt to enable or disable macros when he opens the page so he told me to get rid of it. Now that I deleted the macro the prompt still comes up. Does anybody know how to get rid of this? Thanks
 
Delete ALL text within the module and if it is a "standard" module ie not linkled to the workbook or worksheet, delete that as well

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244
 
You can also disable the 'Enable/Disable' prompt by going to the Tools menu- Macro- Security and switching to the 'Low' setting. Hopefully you already have an anti-virus program that stops any virus' before they get to Excel.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top