If the project is unviewable then you know the template is loaded as an addin. You can make it viewable/editable by opening that file directly (even while it is active as an addin).

If you can see the macro in the View Macros dialog, you can change the 'Macros in' selection to see macros in different templates and thus work out which template the macro resides in.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia