TheSwamp

Code Red => VB(A) => Topic started by: Keith™ on January 01, 2014, 01:13:26 PM

Title: Recent MS Office updates creates problems with VBA
Post by: Keith™ on January 01, 2014, 01:13:26 PM

I had several calls regarding VBA projects and addins that suddenly stopped working after updates from Microsoft. As it turns out, a recent update to MS Office causes problems with macros that use the MSCOMCTL.OCX library.

You may receive an error that the VBA project is corrupted or it may simply refuse to run. Office addins may also stop working or generate errors that erroneously indicate that the security level is too low or that macros have been disabled.

To resolve this situation, you must unregister the MSCOMCTL.OCX library and reregister it using regsvr32.exe

To unregister you will use "regsvr32.exe /u mscomctl.ocx"
To register it, similarly the command is "regsvr32.exe mscomctl.ocx"