Template becomes a Trusted document ?

[stuartgb100]

I have a project saved as a true template.

When I open the template (a copy of the template) for the 1st time, if macros are NOT enabled only one sheet named EnableMacros is visible. This is a prompt for the user to enable macros.

This behaviour is by design.

When macros are enabled, the Open_Event fires and the EnableMacros sheet is hidden, and 3 other sheets are made visible.

This behaviour is also by design.

If I open a copy of the template (when macros are disabled) and then close the workbook having done nothing, then when I open another copy the EnableMacros sheet is visible.

This behaviour is also by design.

However:

If I open a copy of the template and choose to enable macros, then close the workbook without saving,
then when I go back to the template and open a copy, the Enablemacros sheet is hidden, and the 3 other sheets are visible.

How has this been made possible ?

I understood that opening a copy of a template ensured that the template could not be modified.

Wild guess - by opening the template and enabling macros, has somehow the template become some sort of a "trusted document" ?

Thanks.

 

[CalcSux78]

When you "Enable Macros" on a specific workbook, the trust center remembers. Excel won't ask to enable macros on that document unless the filename changes & is re-opened under the new filename.

 

[stuartgb100]

Understood.

Many thanks.