When I open a file, I get a pop-up message indicating that there are macros
in my file. I did not create any macros in this file, nor can I find any
macros (using ToolsMacros). I thought I remember there being an add-in that
would seach for "hidden" macros. Can anyone help me find these macros?

Use ALT+F11 to open the VBEditor
On the left locate your workbook
Right Click on Module attached to it and remove
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RJ" wrote in message
...
When I open a file, I get a pop-up message indicating that there are
macros
in my file. I did not create any macros in this file, nor can I find any
macros (using ToolsMacros). I thought I remember there being an add-in
that
would seach for "hidden" macros. Can anyone help me find these macros?

Could be event code in a Worksheet or Thisworkbook.

Could be an empty module that used to contain macros.

Could be a Form that does nothing.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

I'll bet on Bernard's guess.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 13:39:03 -0800, RJ wrote:

When I open a file, I get a pop-up message indicating that there are macros
in my file. I did not create any macros in this file, nor can I find any
macros (using ToolsMacros). I thought I remember there being an add-in that
would seach for "hidden" macros. Can anyone help me find these macros?