[Webinar] Streamline your web hosting managementRegister Today

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

Disable Office macros in medium-sized domain environment WITHOUT using Group Policy

A customer of ours is having security issues because users are allowed to enable and run Office macros (and are easily tricked into doing so by malware or instructions in spam messages).  

Ordinarily, I would just disable macros across their domain using Group Policy.  However, this customer opted to purchase retail/small business editions of Office in nearly all cases, and using GP to control non-volume licensed MS Office is not supported.  

They have Office 2007, 2010, and 2013 scattered across 75 or so PCs, shared by 150+ users.  In other words, touching each PC to do this manually is basically impractical.

Is there some other, centralized/automated way to control macro behavior?  How would you suggest we solve this problem?
0
AA-in-CA
Asked:
AA-in-CA
  • 3
2 Solutions
 
McKnifeCommented:
Office 2010 can be controlled by GPOs in any edition, so can 2007. 2013 can be controlled using self-built administrative templates. It wasn't before 2016 that Microsoft crippled even that in order to make more money. Maybe you can find those admx to download somewhere (note: I am not talking about microsoft's non-working admx). Else, you'll need to identify the corresponding registry values and deploy those using group policy preferences.
1
 
DrTribosCommented:
This MS article basically covers how to do it via the registry.  So you could write a script to do it.

Lets just hope your clients users receive a script to undo the changes ;-0

https://blogs.technet.microsoft.com/diana_tudor/2014/12/02/microsoft-project-how-to-control-macro-settings-using-registry-keys/
0
 
McKnifeCommented:
Both comments would suggest a registry edit. I recommend a split.
0
 
McKnifeCommented:
Splitting.
0

Featured Post

Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

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