MrExcel Publishing
Your One Stop for Excel Tips & Solutions

removing macros

Posted by James Ellis on January 24, 2002 11:30 AM

Can someone please tell me how to remove macros from my excel spreadsheet?


Posted by Marion on January 24, 2002 1:15 PM

I need to know how to do this too!

I removed them via Tools-Macro - remove (or delete)
but each time I open Excel, it still thinks I have them.

Posted by Chris D on January 24, 2002 1:24 PM

Macros in - this workbook

then delete the ones you don't want

this should help

Posted by James Ellis on January 24, 2002 3:27 PM


Thanks for your help! I removed the macro, but when I open the document, it still asks if I want to run macros. I looked at all of the options (this workbook, the name of the sheet I had open, etc) and I didn't see any macros left. Is there a way to refresh the document to remove the macro?
Please let me know.


James s s in - this workbook

Posted by Chris D on January 25, 2002 11:45 AM

Hi James,

Looks like Marion has a similar problem.... try reading through these threads :


Hopefully it will get you on the right track (just highlight the above address and paste it into your browser address bar)

Hope this helps, I probably won't be able to helps much more on this..