Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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?



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
Macro stop if file in use by other user? Bry Excel Discussion (Misc queries) 5 August 11th 06 04:27 PM
Excel '00, 1st file has macros, how to stop macro in 2nd file? kaptandrews Excel Discussion (Misc queries) 0 May 24th 06 03:07 PM
Double-clicking .xls file opens Excel but doesn't open the file DG Excel Discussion (Misc queries) 4 January 6th 06 02:20 AM
Excel file automatically opens Lost4Now Excel Discussion (Misc queries) 6 December 4th 05 09:35 PM
Macro did not run after download file from net ariffin Excel Worksheet Functions 2 November 6th 04 01:20 AM


All times are GMT +1. The time now is 12:41 PM.

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

About Us

"It's about Microsoft Excel"