Macro warning...but no macros!

[Guest]

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
tools>macro>macros>delete. 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]

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

 

[PCLIVE]

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

 

[Paul B]

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

 

[Guest]

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