I have a workbook which displays the "This workbook contains a macro"
warning when I open it. However if I look in Tools | Macros there's nothing
to be seen.

Is there anywhere else to look?

Jeff

Jeff,
You also have to remove the modules on which the macros were stored have a
look here for details 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


"Jeff Granger" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a workbook which displays the "This workbook contains a macro"
>warning when I open it. However if I look in Tools | Macros there's nothing
>to be seen.
>
> Is there anywhere else to look?
>
> Jeff
>

right click on any sheet tab>view code(to get into the macro editor)>could
be private macro or private module.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Jeff Granger" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a workbook which displays the "This workbook contains a macro"
>warning when I open it. However if I look in Tools | Macros there's nothing
>to be seen.
>
> Is there anywhere else to look?
>
> Jeff
>

Thanks both

Jeff


"Jeff Granger" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a workbook which displays the "This workbook contains a macro"
>warning when I open it. However if I look in Tools | Macros there's nothing
>to be seen.
>
> Is there anywhere else to look?
>
> Jeff
>