Set Excel Trusted Locations Login Script

[powlaz]

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
edit.

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,

MJ

 

[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
signature.

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

See Excel 2003 on digital certificates.


Gord Dibben MS Excel MVP