Re: Can't find my macro

  • Thread starter Thread starter Rick Rothstein
  • Start date Start date
R

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
 
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.
 
Back
Top