I'd like to put a digital signature on my XL2007 project, so internal users
can open from a LiveLink location (it's unsafe for them to make the location
a trusted one), without having to manually enable the macro/activex content.
But for the life of me, I can't figure out where I GET the signature. When I
open the VBA dialog box to add one, there are none to select from.

Hints please?

B Lynn B -

You get the digital signature by purchasing it.

See "Get or create your own digital signature" at

http://office.microsoft.com/en-us/he...997641033.aspx

- Mike
http://www.MikeMiddleton.com


"B Lynn B" <(E-Mail Removed)> wrote in message
news:0AABFB6A-A5B1-471F-A6CD-(E-Mail Removed)...
I'd like to put a digital signature on my XL2007 project, so internal users
can open from a LiveLink location (it's unsafe for them to make the location
a trusted one), without having to manually enable the macro/activex content.
But for the life of me, I can't figure out where I GET the signature. When
I
open the VBA dialog box to add one, there are none to select from.

Hints please?

Thanks! I thought that seemed to be the case when I first looked into it,
but then someone who works near me said he had added one to a file of his.
He seemed to just have one available somehow.

"Mike Middleton" wrote:

> B Lynn B -
>
> You get the digital signature by purchasing it.
>
> See "Get or create your own digital signature" at
>
> http://office.microsoft.com/en-us/he...997641033.aspx
>
> - Mike
> http://www.MikeMiddleton.com
>
>
> "B Lynn B" <(E-Mail Removed)> wrote in message
> news:0AABFB6A-A5B1-471F-A6CD-(E-Mail Removed)...
> I'd like to put a digital signature on my XL2007 project, so internal users
> can open from a LiveLink location (it's unsafe for them to make the location
> a trusted one), without having to manually enable the macro/activex content.
> But for the life of me, I can't figure out where I GET the signature. When
> I
> open the VBA dialog box to add one, there are none to select from.
>
> Hints please?
>
> .
>

If just for your own use on one computer Office has the SelfCert tool for
creating a digital certificate with which you sign your projects.

That may be what your acquaintance was thinking about.

Unfortunately you cannot export the key for this so cannot be used on other
computers.

But if others are linking into your computer it may work.

I have no way of testing so will leave that to you.


Gord Dibben MS Excel MVP


On Fri, 19 Mar 2010 14:40:01 -0700, B Lynn B
<(E-Mail Removed)> wrote:

>Thanks! I thought that seemed to be the case when I first looked into it,
>but then someone who works near me said he had added one to a file of his.
>He seemed to just have one available somehow.
>
>"Mike Middleton" wrote:
>
>> B Lynn B -
>>
>> You get the digital signature by purchasing it.
>>
>> See "Get or create your own digital signature" at
>>
>> http://office.microsoft.com/en-us/he...997641033.aspx
>>
>> - Mike
>> http://www.MikeMiddleton.com
>>
>>
>> "B Lynn B" <(E-Mail Removed)> wrote in message
>> news:0AABFB6A-A5B1-471F-A6CD-(E-Mail Removed)...
>> I'd like to put a digital signature on my XL2007 project, so internal users
>> can open from a LiveLink location (it's unsafe for them to make the location
>> a trusted one), without having to manually enable the macro/activex content.
>> But for the life of me, I can't figure out where I GET the signature. When
>> I
>> open the VBA dialog box to add one, there are none to select from.
>>
>> Hints please?
>>
>> .
>>