VBA Digital Signature not working


P

Phuelgod

I've 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've 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
doesn't 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 don't 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.
 
Ad

Advertisements

M

Michael Fuller

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
upgraded from Windows Vista Home Ultimate (x64) to Windows 7 Home Premiu
(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 erro
saying the macros are disabled. It does not give me the warning asking if
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 roo
certificate store. My macro security is set to disable all macros excep
digitally signed macros. If I change it to trust all macros, it stil
does not work

If I open Excel and change my settings to trust all macros, I can then ope
the file and the macros run normally. I can even change the macro securit
setting back to disable all macros except digitally signed macros, and th
macros still work. If I do not change the macro settings prior to opening th
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 g
through the additional steps of opening excel and changing the macro settings

Thanks for the help

-
Fran

"Do or do not; There is no try
-Yoda

Previous Posts In This Thread:

VBA Digital Signature not working
I have used VBA macros with Excel2007 with no problem until two days ago when
upgraded from Windows Vista Home Ultimate (x64) to Windows 7 Home Premiu
(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 erro
saying the macros are disabled. It does not give me the warning asking if
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 roo
certificate store. My macro security is set to disable all macros excep
digitally signed macros. If I change it to trust all macros, it stil
does not work

If I open Excel and change my settings to trust all macros, I can then ope
the file and the macros run normally. I can even change the macro securit
setting back to disable all macros except digitally signed macros, and th
macros still work. If I do not change the macro settings prior to opening th
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 g
through the additional steps of opening excel and changing the macro settings

Thanks for the help

-
Fran

"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/tutorial...0-c7354940d878/a-framework-to-animate-wp.aspx
 
M

Michael Fuller

Create a new self signed digital signature. After you apply your self-signed signature (from the Visual Basic -> Tools -> Digital Signature... menu, save and close the spreadsheet.

When you re-open the spreadsheet you will see the following message below the ribbon/menu bar: Security Warning Data Connections have been disabled. Click the Options button. Click the "Trust all documents from this publisher" radio button and submit. Macros will now work and will continue to work on subsequent uses.



Michael Fuller wrote:

VBA Digital Signature not working
25-Apr-10

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

Previous Posts In This Thread:

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

VBA Digital Signature not working
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


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorial...4-b0f20bdc955a/parallel-programming-in-c.aspx
 
Ad

Advertisements

M

Michael Fuller

Create a new self signed digital signature. After you
apply your self-signed signature (from the Visual Basic
-> Tools -> Digital Signature... menu, save and close
the spreadsheet.

When you re-open the spreadsheet you will see the
following message below the ribbon/menu bar: Security
Warning Data Connections have been disabled. Click the
Options button. Click the "Trust all documents from
this publisher" radio button and submit. Macros will
now work and will continue to work on subsequent uses.





Michael Fuller wrote:

VBA Digital Signature not working
25-Apr-10

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

Previous Posts In This Thread:

VBA Digital Signature not working
I have used VBA macros with Excel2007 with no problem until two days ago when
upgraded from Windows Vista Home Ultimate (x64) to Windows 7 Home Premiu
(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 erro
saying the macros are disabled. It does not give me the warning asking if
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 roo
certificate store. My macro security is set to disable all macros excep
digitally signed macros. If I change it to trust all macros, it stil
does not work

If I open Excel and change my settings to trust all macros, I can then ope
the file and the macros run normally. I can even change the macro securit
setting back to disable all macros except digitally signed macros, and th
macros still work. If I do not change the macro settings prior to opening th
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 g
through the additional steps of opening excel and changing the macro settings

Thanks for the help

-
Fran

"Do or do not; There is no try
-Yoda

VBA Digital Signature not working
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

Try this
Create a new self signed digital signature. After you apply your self-signed signature (from the Visual Basic -> Tools -> Digital Signature... menu, save and close the spreadsheet.

When you re-open the spreadsheet you will see the following message below the ribbon/menu bar: Security Warning Data Connections have been disabled. Click the Options button. Click the "Trust all documents from this publisher" radio button and submit. Macros will now work and will continue to work on subsequent uses.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorial...4-b0f20bdc955a/parallel-programming-in-c.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top