I had a macro in the file, and then subsequently deleted it from the Tools->Macro menu. I saved the file after doing this, and when I reopen the file Excel still gives me the Macro Warning and asks if I want to Enable/Disable Macros. Why does it do this after I have deleted the only Macro?
How can I prevent this from happening?
Thanks
Try going into VBE and removing the Empty Module Folder. Even though you deleted the Macros from Tools/Macro/Macros/Delete you more than likely still have a Module Folder that needs to be removed.
Right click on any tab choose View Code, in the VBAProject you should find an empty Module Folder.
Last edited by keithl816; 06-04-2007 at 10:23 AM.
Larry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks