If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
Set Excel Trusted Locations Login Script
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 On Mon, 28 Dec 2009 10:27:01 -0800, powlaz wrote: 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 |
Thread Tools | |
Display Modes | |
|
|