Is there a way to locate any subs where code in another sub might be
called?
Example: There have been situations where I have a sub that is now
obsolete, and I want to make sure it is still not referenced in any
other sub.

Is there a quick way within VBA to locate these references, other than
to just read them.

Thanks,
J.O.

See if Rob Bovey's code documenter is a help,
http://www.appspro.com/Utilities/Documentor.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"excelnut1954" wrote in message
ups.com...
Is there a way to locate any subs where code in another sub might be
called?
Example: There have been situations where I have a sub that is now
obsolete, and I want to make sure it is still not referenced in any
other sub.

Is there a quick way within VBA to locate these references, other than
to just read them.

Thanks,
J.O.

To find all of the places that a procedure or funciton is called I would
either comment out the procedure of change the name of it slightly. then just
hit Debug Compile...

If you want to reference a procedure that you are calling (for exampel you
have a line of code "Call MySub()") right click on MySub and select
definition.
--
HTH...

Jim Thomlinson


"excelnut1954" wrote:

Is there a way to locate any subs where code in another sub might be
called?
Example: There have been situations where I have a sub that is now
obsolete, and I want to make sure it is still not referenced in any
other sub.

Is there a quick way within VBA to locate these references, other than
to just read them.

Thanks,
J.O.

Thanks for the info, everyone. This will help.
I appreciate the responses.
J.O.

Jim Thomlinson wrote:
To find all of the places that a procedure or funciton is called I would
either comment out the procedure of change the name of it slightly. then just
hit Debug Compile...

If you want to reference a procedure that you are calling (for exampel you
have a line of code "Call MySub()") right click on MySub and select
definition.
--
HTH...

Jim Thomlinson


"excelnut1954" wrote:

Is there a way to locate any subs where code in another sub might be
called?
Example: There have been situations where I have a sub that is now
obsolete, and I want to make sure it is still not referenced in any
other sub.

Is there a quick way within VBA to locate these references, other than
to just read them.

Thanks,
J.O.