Isn't there an in-between setting? (I have no practical experience with
certificates.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JBeckett" wrote in message
...
Hi Jon,

Thanks for the reply. The only way I get this to work is by setting the
Macro Setting of "Enable all macros". I am prevented from approving this
macro with the setting "Disable all macros except digitall signed macros"
enabled. I realize ultimately the problem exists with the certificate but
I
could more easily part the Red Sea then get this vendor to correct their
certificate so I was hoping there would be a work around for the blocking
of
workbooks with invalid certificates.

-Jason

"Jon Peltier" wrote:

Do the macros work despite the certificate mess when the security level
is
set to medium? You have to approve macros at this level, whereas at high,
you generally will not be asked to approve macros.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JBeckett" wrote in message
...
That is of course obvious but it degrades my security significatly when
I
only want to be able to get this single workbook to work. I want to be
able
to selectively override the mechanism that is blocking the use of an
invalid
digital certificate.

"Office_Novice" wrote:


Check you Macro security setting Tools Macro Security

Try setting them to a lesser level.

"JBeckett" wrote:

I have received a workbook with macros in it. I trust the sender and
the
workbook is signed with a digital signature. However, I receive a
security
alert informing me that the macros have been disabled because the
signature
is invalid and cannot be trusted because the issue of the
certificate
cannot
be found. Despite installing the certificate and adding the document
to
my
trusted folders, I cannot run the macros in this workbook.

Any inpout would be greatly appreciated.