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

MZtools says it can do some of it:

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

--
Regards,
Tom Ogilvy


" wrote:

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

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



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