FeatureAnalysis XLSM not working in Excel 2013
Shai-Hulud
Posts: 9
Hi,
we have just been upgraded to Excel 2013 and the XLSM we were using for feature analysis is no longer working. All Form Controls are "locked" out, i.e. they show up as if in design mode. I tried all "tricks" I could get hold of, such as removing all *.exd files, forcing a recompile of the VBA (thus killing the XLSM's signature) but to no avail.
Is there any updated version out there that works with Excel 2013? I tries the current one but to no avail
Thanks
Kai
we have just been upgraded to Excel 2013 and the XLSM we were using for feature analysis is no longer working. All Form Controls are "locked" out, i.e. they show up as if in design mode. I tried all "tricks" I could get hold of, such as removing all *.exd files, forcing a recompile of the VBA (thus killing the XLSM's signature) but to no avail.
Is there any updated version out there that works with Excel 2013? I tries the current one but to no avail
Thanks
Kai
Comments
Can you try changing your Excel settings to always allow macros without asking? If it doesn't help, try commenting out workbook_open() sub in Excel 2013, and after that check how it works.
Or else try deleting VBE7.DLL and then launch Excel with an .xlsm file it will reinstall VBA and the Macros will work again.
Hope doing this help you out. http://www.repairmsexcel.com