How to determine where a macro is being used

[brentjohn]

Greetings,
If my question has been answered I apologize, but I have searched for the past few hours and cannot find anything.
I am needing to "clean up" the workbook to reduce the size. I have several macros that I believe are not being used and would like to delete them. However, before I delete them I would like to search the workbook to confirm if they are being used or not. I know I can search within the Visual Basic Editor, but how can I search the workbook to find where the macro is being used?

[Logit]

.
You can do a 'search' in the VBE for the macro's name. Select the search area to be the entire project and not the current module. The search / find function is located in the VBE / EDIT / FIND.

You can right click on any button or shape that is being used as a button and attached to a macro ... to see which macro it runs .. then track the path of the macro that way.

[brentjohn]

Logit,
Unless I am doing something wrong, your first suggestion only searches within the VBE, not where the macro is assigned to a button. I am wanting to determine where the macro is being used in the workbook without having to search every button. I was thinking there should be a way of doing that?

[Logit]

.
There may be a means of doing that, but I am not familiar. Sorry.

[mikerickson]

You'ld have to search each cell to see if the formula used any UDF. (and Names and DataValidation and Conditional Formatting to be really complete)
You'd have to loop through each shape on each sheet to look at its OnAction property.