Is there any way to search macros in closed files?

Any suggestions will be appreciated,

Roger