Macros not enabled on a signed certificate

[wpryan]

Hello, I have a bit of a head-scratcher here... I have a file that is full of Macros, and those macros are signed and working on a number of people's computers. One person's computer is not running the macros. He has the "disable all macros except digitally signed macros" enabled. Like I said, the Macros are signed and working on other's computers without problems. He said it happened after the IT department re-installed Windows on his machine, but they are blaming the file. ...any ideas?

 

[Joe4]

He still has to accept signed macros from that signer once for those macros to work. Once he does that once, then it should work. But he needs that initial acceptance. It will not just accpet any signed macros sight unseen.

 

[John_w]

First, he has to add the digital certificate to the current user's Personal store, and possibly also to the Trusted Publishers store. Then in the workbook's VBA editor click Tools -> Digital Signature and choose the certificate. Save, close and reopen the workbook and he should no longer see the macro security banner and the macros should run.

 

[wpryan]

Hi all, thanks for your response. 2 persons out of 15 are having this problem. They accepted to use Macros when they initially opened the file. The banner "do you want to enable Macros" does not appear any more. The macros simply don't work. Funny thing though, I tried to manually run some code on the computers (they are remote employees so I have to do this via Teamviewer), and I get a message that "macros are not enabled", but they told me that they initially enabled them, and anyway like I said the banner doesn't appear. Could this be a Windows setting? As I said before, the file is working on 13 out of 15 person's computers...