I have an Excel spreadsheet developed in Excel 2003. It has many activex controls on the worksheets, such as images, buttons, checkboxes, etc.
If I open this xls file in Excel 2007 when the Trust Center settings for AcvtiveX Controls is set to 'Disable all controls without notficiation, I receive various errors. These errors are occurring when the file's 'auto_open' VBA routine is trying to select certain worksheets.
The error is:
Run-time Error 57121 Application defined or object defined error
The error occurs on the following line in my auto_open code:
Sheets("Probability").Sele
ct
There are several activex controls on this particular sheet.
When I then manually select the 'Probability' sheet in my workbook by clicking the sheet tab, i then get this error:
Can't exit design mode because Control 'Image1' can not be created
If i delete this particular sheet, then the error will then continue to occur on another sheet that has activex controls on it.
Once this file is then saved in Excel 2007 in XLS format, the error will always occur for that file, even if I try and set the Trust Center settings for AcvtiveX Controls back to 'Enable All Controls'
Can anyone explain why this would be occurring, and why after the file is saved in excel 2007 when the activex controls were disabled, it doesnt work when they are enabled again?
