![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
||||
|
||||
![]()
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
![]()
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? |
#4
|
||||
|
||||
![]()
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 |
#5
|
|||
|
|||
![]()
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? |
#6
|
|||
|
|||
![]()
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. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
Alkaufmann | Word | 2 | 05-28-2015 04:22 PM |
Digital Signature invalidates all others? | JCWrs | Word | 0 | 03-08-2013 04:33 AM |