Check for orphan functions

[chris_culley]

Hi there,

I've just started donig some development work on a (large) vba model.
I'm removing some old functionality from it (stripping out unused
macros and buttons).

The easy part of this is removing the "top level" macros; I was
wondering if anyone had any ideas for finding "orphaned" functions -
ones which are coded but never actually called in the rest of the
project?

Any help would be greatfully received

Cheers

Chris

 

[Tom Ogilvy]

MZtools says it can do some of it:

http://www.mztools.com/index.htm

 

[Jim Cone]

Chris,
Do a search for the function name.
If the name is not found outside of the function code then it is not called.
Make sure you do a project wide search.
-then-
Comment out the entire function and compile the project.
If the code compiles the function is not needed.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<[email protected]>
wrote in message
Hi there,
I've just started donig some development work on a (large) vba model.
I'm removing some old functionality from it (stripping out unused
macros and buttons).
The easy part of this is removing the "top level" macros; I was
wondering if anyone had any ideas for finding "orphaned" functions -
ones which are coded but never actually called in the rest of the
project?
Any help would be greatfully received
Cheers
Chris