Defining the security settings

Before you create your tool sheet template, you need to define the Excel security settings.

In the Excel Options dialog box, click Trust Center Settings.

In the Trust Center dialog box, switch to the Macro Settings tab and choose the Disable all macros with notification option, then confirm the dialog boxes by clicking OK.

The advantage of this setting is better protection against undesired macros with unknown content.

The disadvantage of this setting is that every time you open the template *.xlsx file you will have to enable macros manually. The Security Warning will be displayed.

Click Enable content option if you trust the source of the file.

If you choose the Enable all macros option, you will have low protection against macros with unknown content, but you will no more need to care about allowing macros on each session of template editing.

Definition of the security settings is needed only to run the test during the template creation.