View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default 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!