Where are macros saved and how can I tell?
I'm trying to create a template that uses a macro.
Do macros reside IN a template or in a separate file?
I created a template that uses a macro but when I re-open
the template, I cannot find the macro in Tools-Macros--
Macro
However, when I save the template as an XLS, the macro is
there but with a strange dot reference to some other
module.
I need to be able to share this template and macro with
various users (by email etc.) so I need to know where
everything is. I had assumed a macro became part of the
template.