ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File opens with Enable or Disable Macro (https://www.excelbanter.com/excel-discussion-misc-queries/117951-file-opens-enable-disable-macro.html)

animalfriend7

File opens with Enable or Disable Macro
 
I created a macro in a workbook and saved the file. When I reopened the file,
I deleted the macro (didn't need it after all). Then resaved the file. Now,
whenever I open the file, a box still pops up asking if I want to enable or
disable the macro. How can I open the file without the box popping up?

Paul B

File opens with Enable or Disable Macro
 
amimalfriend, you will need to delete the module that it was in also, 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

"animalfriend7" wrote in message
...
I created a macro in a workbook and saved the file. When I reopened the
file,
I deleted the macro (didn't need it after all). Then resaved the file.
Now,
whenever I open the file, a box still pops up asking if I want to enable
or
disable the macro. How can I open the file without the box popping up?





All times are GMT +1. The time now is 08:22 PM.

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