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


"(E-Mail Removed)" 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


<(E-Mail Removed)>
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