Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Digital Signature
I am having an issue with a macro within a workbook I am sending out to other
people. I have no issue running the macro, but when someone tries to open, they get the error "Macros are disabled because the security level is too High and digitally signed Trused Certificate is not attached to the Macros. Request the macros be signed by the author using a certificate issued by a Certificate Authority." How do I get a signature issued by a certificate authority? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Digital Signature
Tools Macros Security Medium. Save the file, reopen, click 'Enable
Macros' and you're in business. Check this out when you have time: http://support.microsoft.com/kb/288985 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Milodie66" wrote: I am having an issue with a macro within a workbook I am sending out to other people. I have no issue running the macro, but when someone tries to open, they get the error "Macros are disabled because the security level is too High and digitally signed Trused Certificate is not attached to the Macros. Request the macros be signed by the author using a certificate issued by a Certificate Authority." How do I get a signature issued by a certificate authority? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Digital Signature
Lot's of companies do not allow security to be set to medium, and then for
obvious reasons. There is a way in which you can export a digital signature and load it on the target machine, but I have lost my instructions:( The best way is for the recipient to create a digital signature on his/her side, and resign the workbook. However, any alterations to the workbook then has to be done on that PC. If you alter the file on your PC, the digital signature is scrapped, and the end user has to re-sign it again. The end user runs selfcert.exe on his/her PC, and creates the signature. Then open the file, disasble macros, click on <Alt<F11, click on Tools, Digital Signature, Choose and OK out. Save the file, close it and reopen, and it works. Maybe one of the guys can tell us how to pass on the original digital signature? "ryguy7272" wrote: Tools Macros Security Medium. Save the file, reopen, click 'Enable Macros' and you're in business. Check this out when you have time: http://support.microsoft.com/kb/288985 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Milodie66" wrote: I am having an issue with a macro within a workbook I am sending out to other people. I have no issue running the macro, but when someone tries to open, they get the error "Macros are disabled because the security level is too High and digitally signed Trused Certificate is not attached to the Macros. Request the macros be signed by the author using a certificate issued by a Certificate Authority." How do I get a signature issued by a certificate authority? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Digital Signature
I think this will tell you what you want to know:
http://www.vbforums.com/showthread.php?t=285212 http://office.microsoft.com/en-us/ex...7811033.aspx#1 Really? Many companies do not allow security to be set to medium? I've worked at many different firms, all over the country, and never encountered this. I couldn't do my job if I couldn't use VBA, and other automation processes. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Kassie" wrote: Lot's of companies do not allow security to be set to medium, and then for obvious reasons. There is a way in which you can export a digital signature and load it on the target machine, but I have lost my instructions:( The best way is for the recipient to create a digital signature on his/her side, and resign the workbook. However, any alterations to the workbook then has to be done on that PC. If you alter the file on your PC, the digital signature is scrapped, and the end user has to re-sign it again. The end user runs selfcert.exe on his/her PC, and creates the signature. Then open the file, disasble macros, click on <Alt<F11, click on Tools, Digital Signature, Choose and OK out. Save the file, close it and reopen, and it works. Maybe one of the guys can tell us how to pass on the original digital signature? "ryguy7272" wrote: Tools Macros Security Medium. Save the file, reopen, click 'Enable Macros' and you're in business. Check this out when you have time: http://support.microsoft.com/kb/288985 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Milodie66" wrote: I am having an issue with a macro within a workbook I am sending out to other people. I have no issue running the macro, but when someone tries to open, they get the error "Macros are disabled because the security level is too High and digitally signed Trused Certificate is not attached to the Macros. Request the macros be signed by the author using a certificate issued by a Certificate Authority." How do I get a signature issued by a certificate authority? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Digital Signature
I suppose it depends on which country then? I am not interested in arguing,
I merely voiced my opinion based on my experience. Any case, thanks for the links you posted, and yes, that did help me! For that I thank you. "ryguy7272" wrote: I think this will tell you what you want to know: http://www.vbforums.com/showthread.php?t=285212 http://office.microsoft.com/en-us/ex...7811033.aspx#1 Really? Many companies do not allow security to be set to medium? I've worked at many different firms, all over the country, and never encountered this. I couldn't do my job if I couldn't use VBA, and other automation processes. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Kassie" wrote: Lot's of companies do not allow security to be set to medium, and then for obvious reasons. There is a way in which you can export a digital signature and load it on the target machine, but I have lost my instructions:( The best way is for the recipient to create a digital signature on his/her side, and resign the workbook. However, any alterations to the workbook then has to be done on that PC. If you alter the file on your PC, the digital signature is scrapped, and the end user has to re-sign it again. The end user runs selfcert.exe on his/her PC, and creates the signature. Then open the file, disasble macros, click on <Alt<F11, click on Tools, Digital Signature, Choose and OK out. Save the file, close it and reopen, and it works. Maybe one of the guys can tell us how to pass on the original digital signature? "ryguy7272" wrote: Tools Macros Security Medium. Save the file, reopen, click 'Enable Macros' and you're in business. Check this out when you have time: http://support.microsoft.com/kb/288985 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Milodie66" wrote: I am having an issue with a macro within a workbook I am sending out to other people. I have no issue running the macro, but when someone tries to open, they get the error "Macros are disabled because the security level is too High and digitally signed Trused Certificate is not attached to the Macros. Request the macros be signed by the author using a certificate issued by a Certificate Authority." How do I get a signature issued by a certificate authority? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Digital Signature | Excel Programming | |||
Simple Macro Needs Digital Signature? | Excel Programming | |||
Assign Personal Digital Signature Macro to files | Excel Programming | |||
Digital Signature | Excel Programming | |||
Digital Signature | Excel Programming |