It's me again!! Error message.
 

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

these are not error messages. they are warnings.
no, you cannot disable them. they are hard coded into
excel.
on the second message, click enable macros. this will
allow you to run your macros.
(if you click disable, your macros will not run.)

-----Original Message-----
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

.

Mom,

It's not an error. It's just letting you know that there are macros
(programs) in the workbook. The macro programming language is powerful
enough that someone could have written something malevolent, like destroy
data and/or propagate itself to other computers via the internet (a virus).
You have to decide whether to let the macros run or not. If you know who
created the workbook (not just who gave it to you), you can best make this
decision.

If you're wrong, you may wind up in another dimension. One without the
internet. If we never hear from you again, we'll know what happened.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pgsmom" wrote in message
...
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

Well....hmmmm.......

Ok....thanks!!

"Earl Kiosterud" wrote:

Mom,

It's not an error. It's just letting you know that there are macros
(programs) in the workbook. The macro programming language is powerful
enough that someone could have written something malevolent, like destroy
data and/or propagate itself to other computers via the internet (a virus).
You have to decide whether to let the macros run or not. If you know who
created the workbook (not just who gave it to you), you can best make this
decision.

If you're wrong, you may wind up in another dimension. One without the
internet. If we never hear from you again, we'll know what happened.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pgsmom" wrote in message
...
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

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

Ok....I received the following formula from Mr.Jason Morin Sunday night
(Messing entitled: "Adding cells, using text as number:"

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim aCtr As Range
Dim cCtr As Range
Set aCtr = Range("B6")
Set cCtr = Range("B8")
If Target.Count 1 Then Exit Sub
If Not Intersect(Target, Range("A1")) Is Nothing Then
With Target
If .Value = "a" Then
aCtr.Value = aCtr.Value + 1
ElseIf .Value = "c" Then
cCtr.Value = cCtr.Value + 1
End If
End With
End If
End Sub

I plugged it in, tweaked it, and added a little to make it work for me
(....and it has), and I come in this morning with the error message. Then I
get told that it could possibly inbed a virus and send me from the face of
the earth screaming, "Why Me?!?!"

Do you think this code could posess those powers?! I'm not real "hip" to
all the language above. I think I figured out what most of it means, but
that doesn't mean I'm right!! Do you think I would be safe in creating this
certificate?! Or do you think I'm going to end up sinking into a pit of
despair?!

Thank you for all your help!!!
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

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

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

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

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

Thank you for all your help!!!

I do think I'll pass on your workbook, although I do appreciate the offer.
I'd be a little scared, especially since I was told I could be wiped from the
face of the earth if something were "encrypted."

Thank you again for all your time and advice!! It's been greatly
informative and appreciated!!!

Pgsmom

"Gord Dibben" wrote:

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

On Wed, 12 Jan 2005 11:51:01 -0800, Pgsmom
wrote:

Thank you for all your help!!!

I do think I'll pass on your workbook, although I do appreciate the offer.
I'd be a little scared, especially since I was told I could be wiped from the
face of the earth if something were "encrypted."

Thank you again for all your time and advice!! It's been greatly
informative and appreciated!!!

Pgsmom

"Gord Dibben" wrote:

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

This message is normal to the security setting MEDIUM for macro's. If you
want to avoid any message decrease the security to LOW, its not recommend but
its either that or messages.

best regards

"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