Find Excel Macros 1

[janetlyn]

I have a workbook containing links. Doing a Tools:Macro:Macros shows the workbook contains no macros. However, when I open the workbook, it gives me a message that the workbook contains macros, do I want to enable......How do I find this errant macro so I can delete it and stop getting the message.

Appreciate any help. Thanks, Janet Lyn

 

[SkipVought]

In your workbook do
alt+F11

This opens the VB Editor

On the Left-hand side is a Project Browser window. Double click on each object in the browser to view the associated code. IF there's any code you my want to just comment it out (highlight code and select the Comment Block tool from the Edit Toolbar

The other thing that you could do if you never want to mess with macros, is set the security to HIGH in Tools/Macro/Security

Hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[janetlyn]

I did what you said and each window opened up was just a blank box, no code. All sheets were empty of code. If I set my security settings to high on macros, then it will give me a message that there are macros in the worksheet but because my settings are so high it will not enable the macros. Either way, I'm going to get a message. Any other suggestions? Thanks for the help, Janet Lyn

 

[SkipVought]

No, Sorry :-( Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[meintsi]

Removing the code is not enough.

You have to delete any modules found. *Remember.......
If you don't use your head,
your going to have to use your feet.

 

[janetlyn]

That worked. Actually I think it was a form not a module that was the problem. Anyway, I deleted anything that was not one of my sheets. Thanks so much for all the help. Janet Lyn