VBA Macros and Windows 7


P

Phuelgod

I have several Office 2007 Excel files that use macros. All are stored as
..xlsm files.

All of the macros are locally signed using the Digital Certificate for VBA
Projects, and my Excel macro security is set to "Disable all macros except
digitally signed macros".

Everything worked just great until last night, when I upgraded from Windows
Vista Home Ultimate to Windows 7 Home Premium. I now get a message telling
me my macros are disabled and to close, then re-open and enable the macros.
Unfortunately, I never get the pop-up message asking me if I want to disable.

Any idea how to get my macros working again?

Thanks in advance!
 
Ad

Advertisements

P

Phuelgod

Phuelgod said:
I have several Office 2007 Excel files that use macros. All are stored as
.xlsm files.

All of the macros are locally signed using the Digital Certificate for VBA
Projects, and my Excel macro security is set to "Disable all macros except
digitally signed macros".

Everything worked just great until last night, when I upgraded from Windows
Vista Home Ultimate to Windows 7 Home Premium. I now get a message telling
me my macros are disabled and to close, then re-open and enable the macros.
Unfortunately, I never get the pop-up message asking me if I want to disable.

Any idea how to get my macros working again?

Thanks in advance!
--
Frank

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


OK, some additional information that I just stumbled upon. I went to look
at the digital certificate to ensure it was there. On the certification
path's tab, it indicates:

"This CA Root certificate is not trusted because it is not in the Trusted
Root Certification Authorities store."

I'm guessing this means I need to move my certificate...would any one like
to share where I can find my Trusted Root Certification Authorities store?

Thanks again!


-Frank
 

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