Re: Work-around for blocking of invalid certificates Excel 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <JBeckett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0E01166D-A4B1-410F-9632-6547390FE850@xxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: You are wonderful
    ... After choosing your certificate you must save the file. ... Set your macro security settings to "Disable with notification" and you will ... get the option to enable or disable macros when you open the workbook. ...
    (microsoft.public.excel.programming)
  • RE: Macro Virus?
    ... I even bought a certificate from Verisign. ... "The macros in this file do not match the digital signature. ... virus would cause this. ...
    (microsoft.public.excel.programming)
  • RE: How can I suppress the enable macros and save changes messages?
    ... prevent the "Save Changes" message when closing the workbook, ... If you are new to macros, this link to Jon Peltier's site may be helpful: ... what would be the use of security settings ... Attach a personal certificate to your workbook (digitally sign the VBA ...
    (microsoft.public.excel.worksheet.functions)
  • Re: macros in Office 2007 (and in office 2003) with self-signed certificates
    ... As an administrator how could I distribute that certificate to the users to use the macros with the least user interaction? ... Is there a good scenario for desktop rollout regarding macros that are signed in Office 2003 and will move to a new OS and Office 2007? ... If you are using SelfCert to create a digital signature it's intended to be used for your macros on your computer. ... The User Templates location is automatically trusted and you can add the Workgroup Templates location as a trusted location in the Trust Center. ...
    (microsoft.public.office.setup)
  • Problem with digital certificate
    ... I created a digital certificate for myself a few days ago, ... The first symptom this morning was that when I opened my workbook a ... "You should not trust macros from this publisher". ... VBA project could not be signed. ...
    (microsoft.public.excel.misc)