ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macros Menu Keeps Appearing (https://www.excelbanter.com/excel-discussion-misc-queries/118640-macros-menu-keeps-appearing.html)

Portocar

Macros Menu Keeps Appearing
 
Even after I have deleted macros from a workbook I still get the menu asking
me if I want to disable or enable the macros when I call up a workbook.
Is there any way to keep from getting this message?
Thanks

Alan

Macros Menu Keeps Appearing
 
You need to delete not only the macro themselves but also the modules that
they reside in. Press Alt an F11 to display the VB editor, on the left youll
see one or more modules. If youre sure you want to delete them, right click
Remove Module 'Do you want to export?' 'No'

Regards, Alan.
"Portocar" wrote in message
...
Even after I have deleted macros from a workbook I still get the menu
asking
me if I want to disable or enable the macros when I call up a workbook.
Is there any way to keep from getting this message?
Thanks




Dave Peterson

Macros Menu Keeps Appearing
 
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

Portocar wrote:

Even after I have deleted macros from a workbook I still get the menu asking
me if I want to disable or enable the macros when I call up a workbook.
Is there any way to keep from getting this message?
Thanks


--

Dave Peterson


All times are GMT +1. The time now is 08:37 AM.

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