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.

--
Frank

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