Set Excel Trusted Locations Login Script



I have a problem with an Excel workbook that I am trying to handle 2
different ways. For the purpose of this post I'm interested in knowing how I
can create a trusted location using a vb script, batch script, or registry

I recently created a workbook that most people in my company need to use.
Everyone's Office 2003 installation has Macro security set to "High". Rather
than walk around to all of the workstations adjusting macro security and/or
setting a trusted location I'd like to just add the folder that houses this
workbook as a Trusted Location but I can't figure it out.

I don't have Sharepoint (I did find a script for this in the MSDN for
Sharepoint) and we don't use Group Policy.

Thanks very much for the help,




Gord Dibben

You want some code which overrides users' security settings?

Virus writers would love to have that code.

Excel 2003 does not have "Trusted Locations"

It has "Trusted Publishers" and to become Trusted you must provide a digital

You can purchase one of these from Verisign or Thawte or similar providers.

See Excel 2003 on digital certificates.

Gord Dibben MS Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question