Windows 10: word 2010 vba macro suddenly prompts to add digital certificate to document

I have no idea if I have selected the correct topic for posting. None of them seem appropriate.I have a macro allocated to Shift+Ctrl+M which has worked happily for years. It strikes-out the current line of text and pre-fixes the line with the date. No magic. No "funny handshakes"; as simple as it gets.Now I get I created a new certificate but all it does is force the document into a final version. If I edit it, the certificate is removed and I'm back to square one.I have tried this1. Check Macro Security Settings: "Enable all macros not recommended;&n

:)

 

Since Windows 10 upgrade, Outlook 2010 certifed macros won't work anymore as Digitally Certified macros

Hell all,

Have upgraded my office PC (Win8.1 x64, Office 2010 Pro) to Win10 Home successfully but have found a security issue.

Since this upgrade, self certified code VBA (ThisOutllookSession,...) within Outlook 2010 won't work anymore.

It seems that the macros are now disabled and are no more triggered on events even they are digitally signed.

As a workaround, to make them working again, I've to downgrade the Macro Security Level in Outlook 2010 from "Notifications for digitally signed macros, all other macros disabled" to "Notifications for all macros".

So it seems that Windows 10 doesn't recognize the "Digital Certificate" anymore.

Please note that this digital certificate remains valid and listed in the Outllook 2010 Trusted Publishers and of course the code remains digitally signed.

Anyone to confirm this issue ?

Any idea how to fix this ?

Regards,

Bernard

 

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Here's the list of Objects shown in the VB Project.





So I then ran your List Sheets VB and it led me to what appears to be the issue.

Your List Sheets Sub created a new sheet and listed all the sheets, including the new one and the VB Procedures and Functions. That set me wondering.

So, working on a copy of the XLS, I ran Document Inspector (DI), Hidden Worksheets only, and let it delete those hidden worksheets. And, as I'd wondered, my macros and functions didn't work, they weren't there, DI had deleted them.

So what appears to be the case is that for this workbook at least, DI sees the VB Procedures and Functions items shown in the VB Object List as hidden worksheets, and so deletes them.

I've run DI on other macro-enable spreadsheets but they just have Module 1 containing the macros and are not seen by DI as hidden sheets.

All rather interesting.

 

Is there VBA in Outlook 2010 running on a Windows 10 system?

I have upgraded to Windows 10 from Windows 7. I had used VBA in Outlook 2010 successfully in the Windows 7 system. Now that I am on Windows 10, I cannot seem to be able to start VBA in Outlook 2010. When I press ALT-F11, nothing happens. How can I
access a VBA macro in Outlook 2010 on a Windows 10 system?