ibanarriola
Posts: 2
Joined: Fri Jun 14, 2013 1:33 pm

Office Add-in installer: set security settings for macros

Is possible to set macro security settings during the installation? I am creating add-ins for customers and when they have the macros disabled or not trusted they get an error and is so annoying for them. So if it is possible to set that during the installation would be perfect.
Dan
Posts: 4529
Joined: Wed Apr 24, 2013 3:51 pm

Re: Office Add-in installer: set security settings for macro

Hello,

We don't have predefined support for this. I'm not sure how you can do this programatically. Maybe the Secure Deployment of Managed COM Add-Ins in Office article may help you.

However, in the Microsoft Office XP Security Settings Matrix I saw that even if the Security level is set to High the Office will Load the add-in or macro silently.
What you have to do is to Digitally sign your add-in and load it from a Trusted sources.

Please note that trusted locations are automatically created when you install the Microsoft Office system.
E.g: The default trusted location for Access 2013 seems to be
Program Files\Microsoft Office 15\Root\Office15\ACCWIZ

You can take a look on the Plan and configure Trusted Locations settings for Office 2013..

With Advanced Installer you have the possibility to Install files in a custom folder. You can try the see if that is working for the files that are added in a trusted location too and also are Digitally signed.

If you need any help, please let us know.

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”