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!

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

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!

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!

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!