It's me again!! Error message.

[Guest]

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

 

[Guest]

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.)

 

[Earl Kiosterud]

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.

 

[Guest]

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

Ok....thanks!!

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.

 

[Gord Dibben]

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 Editor>Tools>Digital
Certificate.

With your workbook open add the DC to it.

Gord Dibben Excel MVP

 

[Guest]

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

 

[Guest]

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]

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

 

[Guest]

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]

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

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

Start>Run "mmc"(no quotes)

When the console opens go to File>Add/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 Details>Copy 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 Tools>Options>Security>Digital
Certificates>Add

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

 

[Guest]

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]

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

 

[Guest]

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