Becoming a Trusted Source

CRWeaks23 · Mar 15th, 2002, 06:54 AM

I was just wondering how to become a "Trusted Source" for a machine to avoid macro messages altogether.

Thanks all
Chris

CRWeaks23 · Mar 15th, 2002, 07:19 AM

Also, is there a way to change macro securities from another macro?

MrExcel · Mar 15th, 2002, 07:32 AM

One way is to pay Verisign $400 for their Office VBA Macro signing certificate.

Then, you can sign all of your projects for one year.

CRWeaks23 · Mar 15th, 2002, 07:53 AM

So, there is no way to create my own certificate, backed by no one, so that for my office workers they can see that it is me and not worry about a "Reliable Certificate?"

MrExcel · Mar 15th, 2002, 08:01 AM

You can "self-sign", but my understanding is that the security (at least on XP) may not accept it if their security is set to High. The help file seems to say it is a corporate setting.

There is a whole topic in the Excel help which explains this. Let me see if I can find it.

Yes - search for "Digital Signature" in help, then look at the topic for "Add a Digital Signature for a file or macro project" Here is the relevant part:

Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed by using such a certificate are referred to as self-signed projects. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons.

_________________
MrExcel.com Consulting

[ This Message was edited by: MrExcel on 2002-03-15 07:03 ]

CRWeaks23 · Mar 15th, 2002, 08:35 AM

I'll look into it, thanks

Mar 15th, 2002, 07:32 AM	#3
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	One way is to pay Verisign $400 for their Office VBA Macro signing certificate. Then, you can sign all of your projects for one year. __________________ Preview my latest book for Free

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 06:54 AM	#1
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	I was just wondering how to become a "Trusted Source" for a machine to avoid macro messages altogether. Thanks all Chris

Mar 15th, 2002, 07:19 AM	#2
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	Also, is there a way to change macro securities from another macro?

Mar 15th, 2002, 07:53 AM	#4
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	So, there is no way to create my own certificate, backed by no one, so that for my office workers they can see that it is me and not worry about a "Reliable Certificate?"

Mar 15th, 2002, 08:01 AM	#5
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	You can "self-sign", but my understanding is that the security (at least on XP) may not accept it if their security is set to High. The help file seems to say it is a corporate setting. There is a whole topic in the Excel help which explains this. Let me see if I can find it. Yes - search for "Digital Signature" in help, then look at the topic for "Add a Digital Signature for a file or macro project" Here is the relevant part: Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed by using such a certificate are referred to as self-signed projects. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons. _________________ MrExcel.com Consulting [ This Message was edited by: MrExcel on 2002-03-15 07:03 ]

Mar 15th, 2002, 08:35 AM	#6
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	I'll look into it, thanks