Cannot find macro in workbook

[kevin.]

I get a macro warning in my workbook but when I go to Tools> Macro> Macros, I see no macros listed. Is there another place to look?

It's more of an annoyance than anything, as this workbook should not have any macros but it prompts me everytime I use this workbook.

[davegugg]

Hold Alt and press F11 to open the VBA IDE. All code pages will be displayed in the VBAProject window, usually on the left hand side. Double click each object to display the code page.

In general, macros denoted private do not show up in the list of macros that is displayed from the Tools menu.

[foxguy]

What is the warning? It may be a security issue.

There are a few reasons why the macro doesn't show up in the list.
The macro needs parameters. It's a Function, not a Sub.

To see all the Subs and Functions press Alt+F11 and Ctrl+R. That will put you in the Project Manager. Double click on any of the lines under your file name to see if there are any macros in that module.

[kevin.]

Dave's idea worked.

The error was just a basic "Enable Macro" or "Disable Macro" warning screen.

Thanks