2

I am trying to find out how I can digitally sign a Microsoft Word macro using a valid 3rd party CA issued VBA code-signing certificate that is installed into the machine rather than the user certificate store.

This signing certificate will be used by many different people. I would like anyone who has access to the machine to be able to use it.

I am using the Digital Signature option in the VBA editor (Alt+F11 > Tools > Digital Signature) to perform the signing process. Unless the certificate is installed into the user certificate store there are no 'Sign as' certificates are available, 'Choose...' shows a warning that 'No certificate available'.

If I move the certificate from the Local Computer > Personal store to the Current User > Personal store then it becomes available for selection.

Can the local machine store be used with MS Word VBA code-signing? I believe that this configuration is possible when signing installers using Visual Studio.

Raystafarian
  • 21,963
  • 12
  • 64
  • 91
prime8
  • 21

1 Answers1

0

See https://serverfault.com/questions/1078351/how-do-i-fix-no-usable-signing-certificates-are-available-in-vba, but that basically boils down to you need to put the certificate in the personal certificate store instead of the local machine store. Mostly because, as @hBy2Py said, "VBA has a severely curtailed feature set".

Bond
  • 1