ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I stop macro alerts for a spreadsheet with no macros in it (https://www.excelbanter.com/excel-discussion-misc-queries/32116-how-do-i-stop-macro-alerts-spreadsheet-no-macros.html)

DKS044

How do I stop macro alerts for a spreadsheet with no macros in it
 
I have a spreadsheet that had a macro in it at one time but it has been
deleted. However, whenever I open the spreadsheet I still receive the macro
warning dialg box. How can I get rid of this?

Paul B

DKS044,
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


"DKS044" wrote in message
...
I have a spreadsheet that had a macro in it at one time but it has been
deleted. However, whenever I open the spreadsheet I still receive the
macro
warning dialg box. How can I get rid of this?





All times are GMT +1. The time now is 09:04 PM.

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