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,583
  • 11
  • 60
  • 89
prime8
  • 21
  • 2
  • VBA has a severely curtailed feature set relative to Visual Studio. If there are no obvious options in the *Digital Signature* dialog for signing with local machine certificates, then it's very likely not possible. – hBy2Py Dec 30 '14 at 02:46
  • 1
    Possible duplicate of [View / install certificates for local machine store on Windows 7](http://superuser.com/questions/647036/view-install-certificates-for-local-machine-store-on-windows-7) – Raystafarian Mar 21 '16 at 14:05
  • Possible duplicate of [Copying data from multiple word docs into one excel sheet](https://superuser.com/questions/645165/copying-data-from-multiple-word-docs-into-one-excel-sheet) – Raystafarian Apr 22 '18 at 22:03

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
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - [From Review](/review/late-answers/1148851) – DarkDiamond Sep 30 '22 at 21:28
  • @DarkDiamond I did "include the essential parts of the answer", which started at "that basically boils down to...". Not really sure what more you would want. – Bond Oct 03 '22 at 12:19