Re: Can't find my macro

[Rick Rothstein]

Type the macro's name in the Immediate window, put the text cursor inside,
or next to, the macro name you just typed and then press Shift+F2

 

[Bob Phillips]

Get hold of a free VBE addin, MZ-Tools, that, amongst other things,

- adds and removes line numbers to and from your code
- provides code stats
- supports a code template library
etc.

You can get it at http://www.mztools.com/v3/download.aspx

 

[OssieMac]

When you open the VBA editor, on the left hand side you should have a project
explorer. If not visible then Ctrl/r should make it visible. You should be
able to navigate through your VBA editor from there.

To actually find all the subs in the VBA editor you can select Edit->Find.
In the Find What: field enter Sub followed by a space and then set the Search
button to current project and keep clicking Find Next. You will iterate
though all the subs in the project. When you find the one you want, look at
the explorer and check which one is semi high lighted (light gray not fully
highlighted as when you click it).

You would find a User Defined function the same way but look for Function
followed by a space.