Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2022, 01:04 AM
harry harry is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Advanced Beginner
Macro digital signature not working
 
Join Date: Jul 2010
Posts: 31
harry is on a distinguished road
Default Macro digital signature not working

I have followed these steps.



1. Create a digital certificate using SelfCert.
2. In Outlook > Developer
- Visual Basic > Tools > Digital Signature; choose the certificate.
- Macro Security > Macro Settings; select "Notifications for digitally signed macros, all other macros disabled."
3. Close Outlook; save VBA project when prompted.

However, when I re-open Outlook, the digital signature is not signed in, and the macros wll not run (Outlook says they are disabled).

How can I fix this?

Last edited by harry; 12-12-2022 at 05:22 AM.
Reply With Quote
  #2  
Old 12-12-2022, 06:38 AM
gmayor's Avatar
gmayor gmayor is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

See Create and employ a digital certificate with SELFCERT.EXE
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-12-2022, 08:52 PM
harry harry is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Advanced Beginner
Macro digital signature not working
 
Join Date: Jul 2010
Posts: 31
harry is on a distinguished road
Default

Thanks for your reply. I followed the instructions on your linked webpage successfully. (A couple of "Next" and "OK" confirmation steps were not mentioned, but I clicked through them OK.)

In Outlook, I repeated the process of choosing the (now trusted) certificate, closing Outlook, and saving the VBA project when prompted.

However, when I re-open Outlook, the digital certificate setup still says "The VBA project is currently signed in as Certificate Name: [No certificate]", and when I attempt to run the macro, it says "The macros in this project are disabled....". It appears the certificate selection is not being saved.

(I originally followed this set of instructions ...
Signing your own macros with SelfCert.exe - HowTo-Outlook
... but I am not getting the prompt mentioned in the last step. ("Since it is the first time that you are using the certificate, you’ll be prompted what to do. Select that you’ll always trust the macros or documents from this publisher and you’re done!")

How can I fix this?
Reply With Quote
  #4  
Old 12-12-2022, 10:09 PM
gmayor's Avatar
gmayor gmayor is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you remove the current signature, you should be able to select the new signature which should have been saved if you follow the instructions.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 12-15-2022, 12:48 AM
harry harry is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Advanced Beginner
Macro digital signature not working
 
Join Date: Jul 2010
Posts: 31
harry is on a distinguished road
Default

Thanks for yor reply; however, it appears something is not working as it should or I am doing something wrong.

As a double-check, I deleted my existing certificate from both the personal and trusted stores, then repeated the whole procedure from scratch, but the result was the same as before. Here is what I did.

- Create certificate "MyName" using selfcert.exe.
- Export certificate "MyName" from personal store to .cer file.
- Import certificate "MyName" from .cer file to trusted store.

- Go to Outlook > Developer > Visual Basic > Tools > Digital Signature > Sign As; click on Choose button. At this point, the certificate I created is displayed (there is no option to specify a store or certificate; the one I created is displayed automatically), and when I click on the link "Click here to view certificate properties", it appears to be the trusted one ("This certificate is intended for the following purposes. - Ensures software came from software publisher ... ", etc.).

- Click on OK. It then says "The VBA project is currently signed as Certificate Name: MyName"

- Go to Outlook > Developer > Macro Security and select option "Notifications for digitally signed macros, all other macros disabled."

- Click on OK, close VBA, close Outlook, click on "Yes" when prompted to save VBA project.

- Re-open Outlook.

- Go to Outlook > Developer > Visual Basic > Tools > Digital Signature. It says "The VBA project is currently signed as Certificate Name: [No certificate]", and macros will not run (it says "The macros in this project are disabled.")

----------
It appears the certificate selection is not being saved when closing Outlook or not loaded when re-opening Outlook?

How can I fix this?
Reply With Quote
  #6  
Old 01-19-2023, 12:30 AM
harry harry is offline Macro digital signature not working Windows 10 Macro digital signature not working Office 2019
Advanced Beginner
Macro digital signature not working
 
Join Date: Jul 2010
Posts: 31
harry is on a distinguished road
Default

After some further research, I found a fix for this, on the following webpage.

Unable to sign Outlook 2010 VBAProject

The fix is to add an extra step (underlined below).

----------
- Create certificate "MyName" using selfcert.exe.
- Export certificate "MyName" from personal store to .cer file.
- Import certificate "MyName" from .cer file to trusted store.

- Go to Outlook > Developer > Visual Basic > Tools > Digital Signature > Sign As; click on Choose button. At this point, the certificate I created is displayed (there is no option to specify a store or certificate; the one I created is displayed automatically), and when I click on the link "Click here to view certificate properties", it appears to be the trusted one ("This certificate is intended for the following purposes: Ensures software came from software publisher ... ", etc.).

- Click on OK. It then says "The VBA project is currently signed as Certificate Name: MyName"

- Click on OK, then click on the Save icon (or File > Save, or Ctrl + S). (If this step is skipped, the digital signature is not saved.)

- Go to Outlook > Developer > Macro Security and select option "Notifications for digitally signed macros, all other macros disabled."

- Click on OK, close VBA, close Outlook, click on "Yes" when prompted "Do you want to save the VBA project 'VbaProject.OTM'?".

- Re-open Outlook.
----------

Now the macro will run without any security prompts.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prompt for digital signature zxmon21 Word VBA 1 10-17-2021 04:05 PM
macOS Digital signature in excel ki_ha1984 Excel 0 10-05-2019 05:31 AM
Timestamp information in digital signature? Tuuska Word 0 10-11-2018 06:41 AM
Macro digital signature not working Digital Signature Alkaufmann Word 2 05-28-2015 04:22 PM
Digital Signature invalidates all others? JCWrs Word 0 03-08-2013 04:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft