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.
Last edited by kevin.; 11-18-2011 at 03:15 PM.
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.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
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.
Dave's idea worked.
The error was just a basic "Enable Macro" or "Disable Macro" warning screen.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks