VBA Macro Will Not Run in Excel 365

Question

I am using Office 365 Insider that I downloaded from the Store. A VBA macro that is contained in my spreadsheet and has always worked in a previous versions of Excel will not run in Excel 365. I have had to "enable all macros" in order to use my spreadsheet with the macro functionality. Apparently, this is occurring because the self-signed digital certificate that I had created no longer exists. How can I create a new self-signed digital certificate that will work with Excel 365?

Answer 1

Run the SelfCert.exe app. Typically in C:\Program Files > Microsoft Office > root > Office16.

Answer 2

Ed,

Thank you for the suggestion; however, it leads no where for me. I am using Office 365 Insider that I downloaded as apps from the Store. Apparently, this version of Office 365 Insider is a very different animal. The folder you pointed me to - where I would find SelfCert.exe - does not exist on my system. Also, I searched my entire C: drive for SelfCert.exe, and it does not exist on my system.

Answer 3

Ahhhh... yeah. The Windows Store version of Office 365 is not the same as the Win32 version. The 32bit code of the apps is identical (no 64 bit version in the store), but things like .COM addins are missing from the store version and won't work - no Power Pivot for example.

I guess selfcert.exe is another. I have 45 .exe files in that folder I listed above. I wonder how many are in your install folder, wherever it is. It could be under AppData. 

It would seem your best bet is to just use the real version of Office 365. The Store version seems to be for those 95% of users, and if you are doing VBA and use SelfCert.exe, you are not in the 95%.

Answer 4

I need some kind of guidance from the Office 365 Insider from Store development team regarding this problem.

There may not be that many users who care about this, but for those of us who do care, it is a large problem. My only option is to "enable all macros" in ALL of my Excel spreadsheets so that I can run the one, indispensable spreadsheet that contains the macro. This opens up my system to malware that executes through VBA macros in Excel. Is Microsoft really prepared to accept the liability for this regression in a key security feature?