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
|