I don't know if this will help or not: MACRO: Find Macros that use Selected Sub-Macro
For more information, see the wiki Searching the Forum for Answers section.