Developed application in Excel 2010 VBA not working in Excel 2007
I developed a VBA driven workbook in Excel 2010 with ActiveX objects.
I have a user with Excel 2007 and the ActiveX Objects are frozen, combo box and command button. She did something that opened the debugger. I added a reference in the VBA editor for Microsoft Active X objects 2.8
But when I tried to test it I got a compile error.
Is Excel 2007 not compatible or is this a security setting issue?
Microsoft ExcelVisual Basic ClassicVBA
Last Comment
Roy Cox
8/22/2022 - Mon
Roy Cox
ActiveX controls can be problematic but they should be backwards compatible from 2010 to 2007.
What's the compile error and maybe attach an example workbook?
Davisro
ASKER
I'm reading that deleting this file will fix it
C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd
What's the compile error and maybe attach an example workbook?