If you know the project/workbook the macro is in, you can just search for that
name.

Inside the VBE
Edit|Find
make sure that you're searching "Current Project"

You may even want to search for:

Sub YourMacroName
or
Function YourFunctionName

to make sure you find it quicker.

If you're in the correct module, you can also use the dropdown at the top right
of the code window to see all the functions/subs that are in that module.



Jeff wrote:

"Dave Peterson" wrote:

You had a couple of replies to yesterday's post--one showed how to pass parms to
known macro name.

But if you don't even know the name of the macro, then how would you ever know
what to pass to them?


Dave

There are a lot of macros. I know the name of the macro but it is called in
another macro. The question is how do I edit that called macro if it is not
in the module I am currently in. Is there some search function that lists
all the macros. It looks like I have to go to every module and search for
the called macro if I want to edit it. This seems to be very tedious.

--

Dave Peterson