Hi, Garry,
In Tools > Macro > Security, set the security level to Medium. Go to
the second tab of that dialog and check the box to trust installed
add-ins and templates.
From then on, you should see a message box asking whether to enable or
disable macros, but only if the macros are in the document itself or
if it's based on a template in a folder other than the standard
Templates folders (listed in Tools > Options > Folder Locations).