Distribute Security Settings

Changing macro security settings on individual computers is fine for personal use, but it doesn’t work very well when trying to manage security for an organization. To solve that problem, Microsoft provides the following tools:

Microsoft Office Resource Kit

Provides the Custom Installation Wizard (CIW) , Custom Maintenance Wizard , and Profile Template Wizard that automate the installation and configuration of Microsoft Office across your organization

Certificate Manager ( CertMgr.exe )

Lets you export, distribute, and install certificates for trusted publishers on users’ machines

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.