Macros and Excel 2013

[jonnathan]

Hello there,

now I got this very annoying situation with my Excel 2013. Ever since some updates were installed, I can't enable macros in Excel. Even after changing to "Enable all macros" in macro settings I receive an Compile error. After switching back to "disable all Macro with notification" the error is in fact gone, but there is no security warning to enable the content after restarting Excel. I tried a number of soultions such as System Restore, reinstalling Visual C++ or even command lines:

regsvr32 - c:\windows\syswow64\mscomctl.ocx
regsvr32 c:\windows\syswow64\mscomctl.ocx

Also reinstalled Office from my PC, but that did not helped either

I don't know, if this is there right place to post a thread like this, but if you could, please help!

I use Windows 7 Pro x64 & MS Office 2013 Pro Plus (x64) with SP1. The compile error when all marcos were enabled: "Compile error in hidden module:frmAutoUpdate".

Thank you,
Jonathan

 

[Drrellik]

A quick search found this.

https://support.microsoft.com/en-us/kb/307410

https://msdn.microsoft.com/en-us/library/office/gg251410.aspx

What add on's have you installed with excel looks like Forms.

~DR

 

[jonnathan]

Hello Drrellik,

thank you for your reply. I have only the standard Add-in's. Problem is still there even after deactivating all of them.

Best,