How to enable the Trust Center macro setting

In order to use the Copy Worksheet feature, you need the Trust Center Macro options to be set to enable Trust access to the VBA project object model.

Depending on your internal IT Policies, you may be able to change the setting yourself or you may need to contact your IT Administrator to discuss whether it is appropriate for this setting to be changed for you.

If it is not possible for this setting to be enabled, then you will not be able to use the Copy Worksheet feature. Use the following instructions to change this setting:

1. Click the File tab.

2. Click Options.

3. Click Trust Center, and then click Trust Center Settings.

4. In the Trust Center, click Macro Settings.

5. Tick the check box next to the Trust access to the VBA project object model option.

6. Click OK.

The following image is the Macro Settings area of the Trust Center.

Note: When you change your macro settings in the Trust Center, they are changed only for the Office program that you are currently using. The macro settings are not changed for all your Office programs.