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

Hello,

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

HTH
Carim

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

MicroMain wrote:

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

--

Dave Peterson

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.

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

MicroMain wrote:

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