Clearing Macros from Workbook

[MicroMain]

For mass data populating purposes, I created a small macro to take care
of a repetitive task. I saved the file and then started using the
macro. Once that was done, I deleted the macro, expecting that all
traces of it would be gone.

Now, when I open the file, it brings up the "this contains macros"
dialog box.

I've gone back in and used Visual Basic Editor and deleted Module 1. I
scanned through the various sheets (within the editor) and don't see
any signs of a macro.

I copied each sheet (Move/copy) into a new workbook, and saved, and
when opening the new one, it still shows the macro dialog box.

How can I remove all traces of there ever having been a macro, so users
don't get this message?


Thanks

 

[Carim]

Hello,

Take a look at Chip's brilliant solution :
http://www.cpearson.com/excel/vbe.htm

HTH
Carim

 

[Dave Peterson]

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[MicroMain]

Thanks Dave,

I read Debra's notes, and checked my file. I didn't have any extra
items besides the standard sheets (having removed module1 earlier). I
did the Cntl-A after opening each of the worksheets vba, and deleted
all text.

Saved the file, went back in and the macro dialog box no longer comes
up.

Success.

 

[Dave Peterson]

Debra has lots of neat stuff at her site. (You may want to bookmark it.)