Locating macros in excel spreed sheets.

[KH7210]

Does any know how to locate a macro that is in a excel spreed sheet?

All help is greatly appreceated.

Thanks
KH7210

 

[AnotherHiggins]

[Alt]+[F11] brings up the VBEditor. If there isn't a panel on the left that resembles windows explorer, press [Ctrl]+[R] to open it. From there you can browse through the different objects that might contain a macro: Workbooks, Sheets, Modules and you can also see Forms.

Is that what you mean?

Oh, if you're getting a message like "Do you want to enable macros" and you can't find any, make sure to remove any and all modules.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[KH7210]

You are right I am getting a message that asks to enable the macros. So I have to find out where they are first. Some of the spread sheet I did not make, and I know I did not put any in my part.

Thanks For the help.
KH7210

 

[AnotherHiggins]

So did you get it sorted out?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[firefytr]

From the PE (Project Explorer), as anotherhiggins specified, right click any Module, Class Module and UserForm, right click them and select remove. Click No on the resulting message box if you do not wish to save/export them. The only other thing you need to do is expand everything in the PE (for that file/project). Then double click all of the sheet modules and the ThisWorkbook module. Delete all code you see. Once you do that, save the workbook, close and re-open.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KH7210]

Thank You all I finally got it straightened out.

KH7210