Inactive Macros

[Candyman]

I want to clean up my db. How do I tell what macros are no longer used?

 

[Jerry Whittle]

The registered verion of Rich Fisher's Find and Replace has a cross-reference
report which can find orphaned queries, modules, macros, and other objects.
It's a bargin for $37.

http://www.rickworld.com/

 

[KARL DEWEY]

You might use the Documentor. It is more work.

Click on TOOLS - Analyze - Documentor. This opens another window.

Click on Queries and select all. Click on Options and select SQL and
Nothing for everything else. Click OK.
Click on Form and select all. Click on Options and select Properties and
Names and Properties. Click OK.
Click on Reports and select all. Click on Options and select Properties and
Names and Properties. Click OK.

Run. Save to Word using Office Links icon on the tool bar and search Word
for the macro name.