Can’t enable macros on 2010

Topic

New Reply

I’m moving my spreadsheets from my XP computer (Excel 2002) to my Win 7 computer (Excel 2010) since XP support ends next year. I use macros that I have (with help from here) written myself. When I open a spread sheet on Win 7 I get a warning that macros have been disabled. When I click on the Options it says that the Macros are disabled because the digital signature (which I signed myself on the other computer) is invalid. It doesn’t expire until 1/1/2018, so it’s not that it has expired. I can show signature details and view the certificate. The Certificate Information says the CA Root is not trusted. To enable trust, install this certificate in the Trusted Root Certification Authorities store. I click on Install Certificate, which opens the Certificate Import Wizard. It automatically selects a certificate store. Then I get a windows that says Completing the Certificate Import Wizard. I click finish and it says the import was successful. I close all the rest of the open boxes and the macros warning goes away. But I still can’t run my macros because “The macro may not be available in this workbook or all macros may be disabled.” If I look in Developer/Macros my macros are there. Saving the workbook as a macro-enabled workbook does solve the problem.

Reply | Quote

Replies

altdotcom,

You can also add the directories/folders where your workbooks are stored to your “trusted locations” in the trust center. HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

That fixed it. Thanks.

Reply | Quote