First you created a certificate with SelfCert and gave it a name, correct?

When you view it you see it is not authenticated, correct?

StartRun "mmc"(no quotes)

When the console opens go to FileAdd/Remove Snap-in

Select Certificates-Current User and OK.

Under Personal Certificates you will see the selfcert you created.

Drag/copy it to the Trusted Certifiicates Folder. Ignore the warnings and
click "Yes".

Select the selfcert by name and double-click and DetailsCopy File.

Choose DER encoded and keep going until you get an "Export Successful"
message.

When complete, close MMC and find the *.CER file.

Your other user will have to install this on his machine.

Double-click to open and select "install".

Open MMC and copy the *.CER from Trusted to Personal Certificates.

User will then have to open Excel and ToolsOptionsSecurityDigital
CertificatesAdd

Then open VBEditor and assign that certificate to the workbook/project.

After all this......The certificate may or not work for user depending upon
his security settings.

As a test I can send you a small workbook with macros and a *.CER file to
install if you email me with your correct address.

Change the DOT and AT to get my email.

Gord


On Tue, 11 Jan 2005 13:07:02 -0800, Pgsmom
wrote:

Did I mention I'm a little slow at this?!

Ok....I found the Microsoft Management Console, but I'm having troubles
figuring out how to move my certificate into the "Trusted Sources"
catagory.....could you give me a little more step by step....I think I'm just
confusing myself....

(Thanks again for all your help!!!)
Mom

"Gord Dibben" wrote:



From Help..............

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. Certificates you create yourself are
considered unauthenticated and will generate a warning in the Security Warning
box if the security level is set to High or Medium.

This from me...............

The help is incorrect when it says "certificates you create yourself are
considered unathenicated and will generate a warning".

Once created and assigned to a VBA Project you will not get the alert about
macros when security is at "medium" and you have checked "always trust this
author" first time the alert comes up.

Back to Help.................

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.

From me again..............

Using the Microsoft Management Console you can move the certificate into the
"Trusted Sources" category and create an exportable *.CER file.

You should be able to then send the *.CER file to the other user for them to
install and use. It is complicated and maybe not worth the effort.


Gord

On Tue, 11 Jan 2005 11:41:04 -0800, Pgsmom
wrote:

Also.....

If I'm wanting to share this particular spreadsheet with someone else, on
their computer, can they open it if I create this certificate?!

Thanks again!!
Mom

"Gord Dibben" wrote:

To get rid of the message completely you can set your macro security to "low"
which I do not recommend.


If for your own use, SelfCert can be used to generate a digital certificate
that will be good on your computer.

See Help on "digital" and select "create your own digital certificates"

Once created, it will be available in Visual Basic EditorToolsDigital
Certificate.

With your workbook open add the DC to it.

Gord Dibben Excel MVP

On Tue, 11 Jan 2005 06:51:07 -0800, Pgsmom
wrote:

Ok...I asked for some help Sunday evening, and received some VALUABLE
information which helped with my problem getting Excel to do what I wanted it
to do.

Now when I open my program this morning, and I'm getting an error message
reading:

"Macros are disable because the security level is set to High and a
digitally signed Trust Certificate is not attached to the macros. To run the
macros, change the security level to a lower setting (not recommended), or
request the macors be signed by the author using a certificate issued by a
Certificate Authority."

I can click "OK" and it goes away. Then I go to Tools; Macro; Security; and
change the security setting to Medium. I close my Excel program, and reopen
it (with all other applications closed), and I get a new errormessage that
reads:

"'C:\Documents and Settings\My Documents\January.xls' contains macros.
Macros may contain viruses. It is usually safe to disable macros, but if
the macros are legitimate, you might lose some functionality."

I can choose to 'Disable Macros' or 'Enable Macros'.....

Do you have any ideas what this means, and what i can do to make the error
messages go away completely?!

Any feedback would be greatly apprecited!!!
Pgsmom