VBA and ActiveX Compatibility

[Jester0001]

I created a workbook in Excel 2010 that contains VBA and ActiveX control buttons. However, when the workbook was tested on Excel 2007 and 2003, there were compatibility issues.

Excel 2007 issues (there may be more as I get further into debugging):

Please Login or Register  to view this content.

The code would return an Error 5 Invalid Procedure Call or Argument at the red highlighted portion. This bit of code is to check the values of the range with the values in another worksheet, and if any values are not equal, then to conditionally format the not equal values red.

Excel 2003 issues:

Upon opening the workbook, Excel says "Uninitialized ActiveX Controls will not be opened in this version of Excel".

Also, I have this code in the workbook_open() event:

Please Login or Register  to view this content.

This code stops at the red text, and I am not sure why. This code is to clear the contents of the range on the specified worksheet.

I would like this workbook to be versatile and compatible between Excel 2010, 2007, and 2003 without losing much existing functionality. Any help, assistance, or feedback is appreciated.

[Andy Pope]

You really should build the workbook in oldest version as it will stand more chance of working in the newer version.

Stuff like TintAndShade are not present in xl2003.

Are you sure the sheet names are correct. Do you have 2 worksheets, "Level 1" and "Level 1 Key" or is one a typo.

[Jester0001]

Andy,

Thank you for the advice. I was afraid I was going to have to take that route, but I didn't want to as I know that if I build it in 2003, then it might not look as visually appealing in 2010. And yes, the worksheet names are correct. The application fully works in 2010.

Back to the drawing board!