Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
If you open this file with or without macros enabled and then save it,
doesn't this remove the certificate? And if it does, can you then go back to medium security for all files? A one time hassle every time you get a new file but... -- Jim "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. | | | |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for blocking of invalid certificates Excel 2007
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007. Self Digital Signature invalid, can't del. | Excel Discussion (Misc queries) | |||
Excel 2007 link is invalid after referenced book is replaced | Links and Linking in Excel | |||
Help! Names defined in Excel 2003 invalid in Excel 2007 | Excel Discussion (Misc queries) | |||
Invalid web query Excel 2007 | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming |