Opening a workbook from a template results in it opening in Design Mode. Right clicking to Open the Template, the Design Mode is not on.
This particular Excel Template was originally created in excel 2003 with a calendar control.
When I upgraded to Excel 2007, the calendar control no longer functioned, so I used the Date Picker. Date Picker worked for many months. Now when double clicking the template the resulting excel workbook displays the message, Can't exit design mode because control 'DatePicker1' can't be created. Choose OK, and now you can click exit Design Mode and enable Macros/ActiveX.
Saving as .xlsm from the .xltm creates a workbook that opens normally (without being in Design Mode).
Saving the .xlsm as .xltm makes the resulting excel Template open in Design Mode.
Saved as .xlsx does not open in Design Mode, ActiveX works, macros aren't there.
Saved as .xls from .xltm does not open in Design Mode.
Saved as .xls from .xlsm does not open in Design Mode.
Saved as .xlt from .xls opens in Design Mode.
Saved as .xlt from .xltm opens in Design Mode.
I have tried this over and over with various save combinations with the results being that double clicking to open a template results in the workbook opening in Design Mode.
How can I turn it off and keep it off?