2016 Outlook Certificate Problems

Status
Not open for further replies.

Calendar

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
1. On a brand-new home installation of Office 365 (currently 2016), I opened Outlook and created three new calendars, then copied the very nice Slipstick VBA macro to open Outlook at the calendar with two calendars selected, adapting the cases in the macro in the obvious way. It worked well, briefly, then it wanted a certificate.

2. I created a certificate using SELFCERT. Then using MMC, I found the new certificate in 'Current User/Personal' and copied it (right-click Copy, then right-click Paste) into 'Current User/Trusted Root Certification Authorities'. I was unable to copy it into '(Local Computer)/Trusted Root Certification Authorities'.

3. In Outlook's VBA editor, I signed Project1 with this certificate. Then I exited Outlook, saving the project.

4. Every time I opened Outlook, however, I got the error message, 'An error occurred while attempting to verify the VBA project's signature. Macros will be disabled.' Then whenever I went into the VBA editor, I found that the project was unsigned again.

5. So I deleted the macro, intending to go back to 'Outlook-out-of-the-box' (but understandably I cannot delete Project1). There are now no macros to display, yet every time I start Outlook, I get the same error message, despite the fact that I keep trying to sign Project1 with my certificate. I've also set 'MacroSettings' temporarily to the lowest level, which one would expect should bypass certificates. Thus I am completely stuck, because I cannot even go back to where I was before I started doing all this.

QUESTION: Presumably I am doing something wrong with the Certificate, but I have googled obessively and read numerous blogs on the subject, and tried all sorts of suggestions proposed there, and I can't sort it out. Does anyone have any clues about all this? I know that Windows is obscure, but I have never struck anything like this --- it's held me up for hours.

Windows 10 Pro 1709 on 64-bit desktop, with ESET Smart Security 9, and VPN by Private Internet Access
 
It worked well, briefly, then it wanted a certificate.
Was the security level changed?

Then using MMC, I found the new certificate in 'Current User/Personal' and copied it (right-click Copy, then right-click Paste) into 'Current User/Trusted Root Certification Authorities'.
Don't move /copy it, you can trust it in the Trust Center or in the allow macros dialog.

(but understandably I cannot delete Project1)
You can delete it from the hard drive. Outlook will create a fresh clean copy the next time you open the VBA editor. It's at %appdata%\microsoft\outlook
 
Was the security level changed?


Don't move /copy it, you can trust it in the Trust Center or in the allow macros dialog.


You can delete it from the hard drive. Outlook will create a fresh clean copy the next time you open the VBA editor. It's at %appdata%\microsoft\outlook
 
Fixed! And it all survived reboot! (And apologies for mucking up the reply a few minutes ago.)

1. I deleted the project file as you advised, and everything returned to what it was before I started fiddling with VBA macros. What a relief!

2. After closing and relaunching Outlook a couple of times, I set the Trust Centre's Macro Settings to 'Notifications for all macros' --- I'm not sure whether this was the best choice, but it has worked. When I restarted Outlook, I had to give permission to various certificates, but it was very straightforward to check that each was genuine.

By the way, I had tried various settings of the security level before, but none of them had worked.

3. I then repasted the adapted 'SelectCalendars()' macro text into a new module of Project1, ran it a couple of times to check it, then digitally signed it. I had copied, not moved, the Certificate previously, so I did not even launch MMC --- nevertheless everything worked as it should. (The extra copy of the Certificate should surely not be a problem.)

Thank you, Slipstick, for the very useful macro, and than you very much, Diane, for helping me sort out the Certificate business. It was all too subtle for me.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
S Outlook 2016 and Acrobat PDFMaker Office COM Addin Using Outlook 0
W Outlook 2016 MSI - Possible to make work with O365 modern Auth & Win7? Using Outlook 4
J Outlook 2016 Trying to get Outlook 2016 to work with Office 365 Using Outlook 0
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
J Outlook 2016 Can't display some embedded HTML images in Outlook 2016 Using Outlook 2
J Outlook 365 Outlook 2016/365 Contacts Lose Info when Favorited to the To-Do Bar Using Outlook 2
O Moving "tasks" to inbox in Outlook 2016 Using Outlook 1
Z Remove GMAIL IMAP account from Outlook 2016 Using Outlook 2
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
bhamberg Shortcuts in Folder Pane (Outlook 2016) Using Outlook 19
G Outlook 2016: Want IMAP Data Files on My D: Drive and Not C: Drive Using Outlook 1
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
P Color Code or highlight folders in Outlook 2016 Using Outlook 2
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
M Issue transferring Outlook 2016 email accounts & settings onto new computer Using Outlook 8
glnz Can Word Normal.dotm interfere with Outlook? Office 2016 Using Outlook 5
D Outlook 2016 and Earlier with Office365 in 2021 Using Outlook 3
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
V Outlook 2016 Does Outlook-2016 (64 bit) work with iCloud for Windows ? Using Outlook 5
R Microsoft Outlook 2016 - Gmail not sending, asks for password for SMTP, tried different ports Using Outlook 23
V Outlook 2016 Outlook-2016 and iCloud for Windows - Problems Using Outlook 11
U Outlook 2016 Outlook 2016 sender name Using Outlook 1
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
A Backup Email Accounts On OutLook For Mac 2016 (Microsoft 365 subscription version) Using Outlook 0
M Office 2016 Outlook is forgetting passwords Using Outlook 15
E Can one still buy Outlook (or Office) 2016? Using Outlook 6
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
G Recurring tasks break links Outlook 2016 Using Outlook 5
A How to get body of all emails in outlook 2016 to view in blue color Using Outlook 1
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
GregS Outlook 2016 iPhone won't download Outlook 2016 Mail. Using Outlook 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 6
V Outlook 2016 will not move emails in search results Using Outlook 4
K Using Outlook 2016 to draw Using Outlook 1
M Outlook 2016 Free/Busy settings ignored Using Outlook 0
K Outlook 2016 - controlling IMAP OST size with Group Policy not working Using Outlook 1
C Outlook 2016/2019 hangs after being open for an extended period Using Outlook 4
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
A Outlook 2016 in Cached Mode Using Outlook 1
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
N Outlook 2016 Folder Icons Look Using Outlook 0
Marc2019 Outlook 2016 Font Problem Using Outlook 5
B Outlook 2016 Does not Shutdown Correctly Using Outlook 3
GregS Outlook 2016 Outlook 2016 stalls Using Outlook 3

Similar threads

Back
Top