I'm designing spreadsheets that use macros for a health care facility for
free. I'd like to be able to sign the macros with a trusted certificate so
they don't have to go through the rigmarole of changing macro security
settings to medium or low. Any advice on best/cheapest way to get such a
certificate would be much appreciated, and acknowledged.

TIA,

Dan E

--
Dan E
webbie(removethis)@preferredcountry.com

See this site:

http://msdn.microsoft.com/library/de...otcertprog.asp

"Dan E" wrote:

> I'm designing spreadsheets that use macros for a health care facility for
> free. I'd like to be able to sign the macros with a trusted certificate so
> they don't have to go through the rigmarole of changing macro security
> settings to medium or low. Any advice on best/cheapest way to get such a
> certificate would be much appreciated, and acknowledged.
>
> TIA,
>
> Dan E
>
> --
> Dan E
> webbie(removethis)@preferredcountry.com
>
>
>

Dan, this may be and option, it would be the "cheapest" way I think, but you
would have to put it on each computer there.

This applies to Excel 2000 and newer versions

You can create a self-signed digital certificate to use on your files with
SelfCert.exe, the file with the certificate is allowed to be opened with no
warning.

To use SelfCert.exe,
Open Windows Explorer and find your Office folder. Find SelfCert.exe and
run it. Or use find, start find, files or folders, type in SelfCert.exe and
search your hard drive, double click on it from there to run it

This certificate is good only on your computer, but it can be assigned to
more than
one file.

Once you have created the certificate open the file you want to sign, go to
the
VB Editor, Alt.+ F11, and select your VBA project.

Tools, Digital Signature, Choose. Select the Certificate you just created.

OK till you are out and save your file.

The next time you open this file you will not get the warning.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
news:(E-Mail Removed)...
> I'm designing spreadsheets that use macros for a health care facility for
> free. I'd like to be able to sign the macros with a trusted certificate
so
> they don't have to go through the rigmarole of changing macro security
> settings to medium or low. Any advice on best/cheapest way to get such a
> certificate would be much appreciated, and acknowledged.
>
> TIA,
>
> Dan E
>
> --
> Dan E
> webbie(removethis)@preferredcountry.com
>
>

Many thanks for your input, JLG. Doesn't look like there's an individual
code signing certificate available cheaply. I guess that's the way it
should be, since they have to verify identity etc. I guess I'll just have
to email instructions to the users to set macro security to Medium.

Dan E
"JLGWhiz" <(E-Mail Removed)> wrote in message
news:7B75517E-F3D7-4D15-A658-(E-Mail Removed)...
> See this site:
>
> http://msdn.microsoft.com/library/de...otcertprog.asp
>
> "Dan E" wrote:
>
>> I'm designing spreadsheets that use macros for a health care facility for
>> free. I'd like to be able to sign the macros with a trusted certificate
>> so
>> they don't have to go through the rigmarole of changing macro security
>> settings to medium or low. Any advice on best/cheapest way to get such a
>> certificate would be much appreciated, and acknowledged.
>>
>> TIA,
>>
>> Dan E
>>
>> --
>> Dan E
>> webbie(removethis)@preferredcountry.com
>>
>>
>>

Many thanks Paul - actually I've already done that, but as you say, it's
only good on my computer. XP doesn't seem to allow the private key to be
exported, which is what Knowledgebase/Technet says you need to do, so I'll
just email the users instructions for setting macro security to medium -
certs are just tto expensive.

Thanjs again.

Dan E
"Paul B" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dan, this may be and option, it would be the "cheapest" way I think, but
> you
> would have to put it on each computer there.
>
> This applies to Excel 2000 and newer versions
>
> You can create a self-signed digital certificate to use on your files with
> SelfCert.exe, the file with the certificate is allowed to be opened with
> no
> warning.
>
> To use SelfCert.exe,
> Open Windows Explorer and find your Office folder. Find SelfCert.exe and
> run it. Or use find, start find, files or folders, type in SelfCert.exe
> and
> search your hard drive, double click on it from there to run it
>
> This certificate is good only on your computer, but it can be assigned to
> more than
> one file.
>
> Once you have created the certificate open the file you want to sign, go
> to
> the
> VB Editor, Alt.+ F11, and select your VBA project.
>
> Tools, Digital Signature, Choose. Select the Certificate you just
> created.
>
> OK till you are out and save your file.
>
> The next time you open this file you will not get the warning.
>
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
> news:(E-Mail Removed)...
>> I'm designing spreadsheets that use macros for a health care facility for
>> free. I'd like to be able to sign the macros with a trusted certificate
> so
>> they don't have to go through the rigmarole of changing macro security
>> settings to medium or low. Any advice on best/cheapest way to get such a
>> certificate would be much appreciated, and acknowledged.
>>
>> TIA,
>>
>> Dan E
>>
>> --
>> Dan E
>> webbie(removethis)@preferredcountry.com
>>
>>
>
>