VBA Digital Signature not working
in [Programming]
|
From: Michael on 25 Apr 2010 12:01 Have you found a solution to this yet? I have the same exact problem except I did not upgrade. I purchased a new computer in March with OS of Windows 7 Home Premium (x64) and didgital signatures do not work as you indicate in your problem description. On my old computer was running Vista I did not have a problem. On the new computer, whether I create a brand new spreadsheet with a macro and ditially sign it with a local certificate, or I apply my digiital signature to a spreadsheet I copied from my old computer, I can not use the macros. Another difference from your posting is that if I change Excel to trust all macros it does work, but I prefer not to leave this option enabled. Thanks, Mike Phuelgod wrote: VBA Digital Signature not working 04-Dec-09 I have used VBA macros with Excel2007 with no problem until two days ago when I upgraded from Windows Vista Home Ultimate (x64) to Windows 7 Home Premium (x64). Since then, I can only get my macros to work one way... If I open the workbook directly and try to run the macro, I get an error saying the macros are disabled. It does not give me the warning asking if I want to enable the content. The macro is signed with a local certificate, and I have verified the certificate is trusted and in the trusted root certificate store. My macro security is set to disable all macros except digitally signed macros. If I change it to trust all macros, it still does not work. If I open Excel and change my settings to trust all macros, I can then open the file and the macros run normally. I can even change the macro security setting back to disable all macros except digitally signed macros, and the macros still work. If I do not change the macro settings prior to opening the file, the macros are disabled. How do I get the macros to run upon opening the file normally (for example, from my recent documents list or my documents folder), without having to go through the additional steps of opening excel and changing the macro settings? Thanks for the help. -- Frank "Do or do not; There is no try" -Yoda Previous Posts In This Thread: On Friday, December 04, 2009 10:54 PM Phuelgod wrote: VBA Digital Signature not working I have used VBA macros with Excel2007 with no problem until two days ago when I upgraded from Windows Vista Home Ultimate (x64) to Windows 7 Home Premium (x64). Since then, I can only get my macros to work one way... If I open the workbook directly and try to run the macro, I get an error saying the macros are disabled. It does not give me the warning asking if I want to enable the content. The macro is signed with a local certificate, and I have verified the certificate is trusted and in the trusted root certificate store. My macro security is set to disable all macros except digitally signed macros. If I change it to trust all macros, it still does not work. If I open Excel and change my settings to trust all macros, I can then open the file and the macros run normally. I can even change the macro security setting back to disable all macros except digitally signed macros, and the macros still work. If I do not change the macro settings prior to opening the file, the macros are disabled. How do I get the macros to run upon opening the file normally (for example, from my recent documents list or my documents folder), without having to go through the additional steps of opening excel and changing the macro settings? Thanks for the help. -- Frank "Do or do not; There is no try" -Yoda Submitted via EggHeadCafe - Software Developer Portal of Choice A Framework to Animate WPF and Silverlight Pages Similar to the PowerPoint Slides http://www.eggheadcafe.com/tutorials/aspnet/7390a840-dd39-4c35-9940-c7354940d878/a-framework-to-animate-wp.aspx
|
Pages: 1 Prev: C application connected to Excel Next: Excel and Windows Live Mail |