[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Using GPO to disable Macros on Office files except from specific Location

Hello
i am trying to disable macros from running in all Office programs with GPO, except on a specific Location.
Following GPO i set up:

Policies/Administrative Templates/Microsoft Office 2016/Security Settings:
Disable VBA for all Office Programs: activated

Policies/Administrative Templates/Microsoft Office 2013/Security Settings/Trust Center:
Trusted Location 1: C:\Macros with Subfolder enabled

At the moment all Macros are disabled, the same for Documents with Macros under C:\Marcos
Its very hard to make the symstem save from macros only on a specific Location.

Please let me know what i am missing.

Thanks for your help
0
Sven Schmidt
Asked:
Sven Schmidt
  • 2
2 Solutions
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
Why would you possibly want to prevent any macros from running? They help tremendously with productivity. If I worked in a place that did that, I would certainly quit.
0
 
Randy DownsOWNERCommented:
Maybe this will help.

.... By default, only Trusted Locations that are on users' hard disks are allowed. To enable Trusted Locations on network shares, you must enable the Allow Trusted Locations on my network (not recommended) setting.

.... Office 2013 provides several settings that enable you to restrict or control the behavior of Trusted Locations. Use the following guidelines to determine how to configure these settings.

Group Policy Setting name: Allow mix of policy and user locations
- Impact: If this setting is disabled, all Trusted Locations that aren’t created by Group Policy are disabled and users can’t create new Trusted Locations in the Trust Center. Disabling this setting will cause some disruption for users who have defined their own Trusted Locations in the Trust Center. Applications treat such locations as they treat any other untrusted locations.....


Group Policy Setting name: Allow Trusted Locations on the network
- Impact: Disabling this setting disables all Trusted Locations that are network shares and prevents users from selecting the Allow Trusted Locations on my network (not recommended) check box in the Trust Center. Disabling this setting will cause some disruption for users who have defined their own Trusted Locations in the Trust Center
0
 
Randy DownsOWNERCommented:
assigned points
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now