Macro warning...but no macros!
 

I have deleted all macros that i can find in my workbook (I found a way to
make my document work without them). I did the traditional
toolsmacromacrosdelete. I also went into the VBA editor and removed all
of the Modules I saw. I am still getting the notice about enabling or
disabling macros each time I open the document. I don't want to decrease the
security, and my boss is insisting that I get rid of the warning. Somebody
help! I must be missing a macro somewhere. I just need to get my document
macro free and warning free!

Macro warning...but no macros!
 

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

slfarns wrote:

I have deleted all macros that i can find in my workbook (I found a way to
make my document work without them). I did the traditional
toolsmacromacrosdelete. I also went into the VBA editor and removed all
of the Modules I saw. I am still getting the notice about enabling or
disabling macros each time I open the document. I don't want to decrease the
security, and my boss is insisting that I get rid of the warning. Somebody
help! I must be missing a macro somewhere. I just need to get my document
macro free and warning free!

--

Dave Peterson

Macro warning...but no macros!
 

In the VBA editor, in addition to deleting the modules...double-click on
each sheet and if any code shows on the right-hand pane, then remove it.
Even if there is just a Sub and End Sub with nothing in between, remove it.
Do the same for ThisWorkbook.

HTH,
Paul

"slfarns" wrote in message
...
I have deleted all macros that i can find in my workbook (I found a way to
make my document work without them). I did the traditional
toolsmacromacrosdelete. I also went into the VBA editor and removed
all
of the Modules I saw. I am still getting the notice about enabling or
disabling macros each time I open the document. I don't want to decrease
the
security, and my boss is insisting that I get rid of the warning.
Somebody
help! I must be missing a macro somewhere. I just need to get my
document
macro free and warning free!

Macro warning...but no macros!
 

slfarns, did you check each sheet for code?
have a look here for all the details on where to look

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


"slfarns" wrote in message
...
I have deleted all macros that i can find in my workbook (I found a way to
make my document work without them). I did the traditional
toolsmacromacrosdelete. I also went into the VBA editor and removed
all
of the Modules I saw. I am still getting the notice about enabling or
disabling macros each time I open the document. I don't want to decrease
the
security, and my boss is insisting that I get rid of the warning.
Somebody
help! I must be missing a macro somewhere. I just need to get my
document
macro free and warning free!

Macro warning...but no macros!
 

Thank you to all!!!! You were all very helpful and my problem is solved!

"Paul B" wrote:

slfarns, did you check each sheet for code?
have a look here for all the details on where to look

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


"slfarns" wrote in message
...
I have deleted all macros that i can find in my workbook (I found a way to
make my document work without them). I did the traditional
toolsmacromacrosdelete. I also went into the VBA editor and removed
all
of the Modules I saw. I am still getting the notice about enabling or
disabling macros each time I open the document. I don't want to decrease
the
security, and my boss is insisting that I get rid of the warning.
Somebody
help! I must be missing a macro somewhere. I just need to get my
document
macro free and warning free!