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



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: Word forms and security issues
    ... If you use only form fields combined with macros, ... For that you need a digital certificate, ... certificate will open without prompts regardless of the security level. ... But are those issues only for form controls that use activex? ...
    (microsoft.public.word.docmanagement)
  • Re: Macro Xcel Windows
    ... If using XL97, macro security is on or off, no levels. ... Before setting your security to "low" which will let every file with macros ... You can create a digital certificate and use that on your VBAProject so only ... that file with the certificate is allowed to be opened with no warning. ...
    (microsoft.public.excel.misc)
  • Re: Macro/keyboard shortcut to increment a cell value
    ... You will get a warning, but your macros will run when you ... Look for selfcert.exe and run it to create a certificate. ... >Word macros and never had a security problem. ...
    (microsoft.public.excel.newusers)
  • 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)
  • Trusting myself
    ... I have an old Excel document with embedded macros. ... I can set my security to medium, open the document, and tell it to run ... In Microsoft Windows XP, on the Windows Start menu, point to All ... and then click Digital Certificate for VBA Projects. ...
    (microsoft.public.office.misc)