Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 28th 09, 07:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 3
Default 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   Report Post  
Old December 29th 09, 06:45 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default 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


  #3   Report Post  
Old May 9th 11, 10:23 AM
Banned
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 29
Default

Quote:
Originally Posted by Gord Dibben View Post
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
I agree with the Gord here, you can have a verified Digital Signature which you can use for the security of your document, and there are so many verisign provider on the internet, you can just find the website of the service providers and can buy a digital certificate and signature for you.

____________
Digital Signature

Last edited by martincrow : May 25th 11 at 10:23 AM


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow Trusted Locations on my network - Group Policy (GP) AKA Bones Excel Discussion (Misc queries) 2 June 11th 09 03:12 PM
VBA Code to Login to Excel Gimp Excel Discussion (Misc queries) 1 February 16th 07 06:38 PM
Configuring Excel 2003 to control access to Trusted Publishers [email protected] Excel Discussion (Misc queries) 0 July 10th 06 09:04 AM
Q:Excel/ODBC/Login .... MSweetG222 Excel Discussion (Misc queries) 1 July 24th 05 06:37 PM
Excel Driver login failed [email protected] Excel Discussion (Misc queries) 1 January 19th 05 01:34 AM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017