AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
Suddenly my .xls file won't run. I'm getting "Can't exit design mode because Control 'label2' can not be created".
I've Googled for help with this and found quite a few mentions but no solutions yet. Microsoft say
Open your Normal.dot, access the control, and then save and close the Normal.dot template. -or-
If you have Visual Basic for Applications code that runs when you access the control, run the procedure prior to saving and
closing the Normal.dot template.
However I don't know where/how to open Normal.dot or what procedure they're talking about. It happens as soon as the spreadsheet opens.
Something else Microsoft say:
"The control specified in the error message dialog box could not be created. Code can only run after all controls are instantiated
and properly connected. Make sure every file needed for the control is available before trying again. "
What's an ordinary bloke meant to do with that!? I'm not even sure what 'instantiated' means, where the control is, how to see if it's
properly connected, or what files are needed.
Others say it is 'Computer specific' and this seems correct as the xls runs ok on another computer. I have re-installed Office
but the problem is still there. (I'm a bit suspicious about the re-instal as it showed a history of previously opened files.
If it were a new install how would it know?)
I was intending to rebuild everything, component by component, but if it's ok on another computer doesn't that prove the 'problem' is somewhere else ?
I don't know what 'label2' is or even if I have one. I've also tried Excel safe mode and a windows XP system restore, nothing made any difference
(although system restore failed).
Any suggestions or help to fix this REALLY appreciated. Has anyone had this error and recovered from it ?
Thanks, ADKM
I've Googled for help with this and found quite a few mentions but no solutions yet. Microsoft say
Open your Normal.dot, access the control, and then save and close the Normal.dot template. -or-
If you have Visual Basic for Applications code that runs when you access the control, run the procedure prior to saving and
closing the Normal.dot template.
However I don't know where/how to open Normal.dot or what procedure they're talking about. It happens as soon as the spreadsheet opens.
Something else Microsoft say:
"The control specified in the error message dialog box could not be created. Code can only run after all controls are instantiated
and properly connected. Make sure every file needed for the control is available before trying again. "
What's an ordinary bloke meant to do with that!? I'm not even sure what 'instantiated' means, where the control is, how to see if it's
properly connected, or what files are needed.
Others say it is 'Computer specific' and this seems correct as the xls runs ok on another computer. I have re-installed Office
but the problem is still there. (I'm a bit suspicious about the re-instal as it showed a history of previously opened files.
If it were a new install how would it know?)
I was intending to rebuild everything, component by component, but if it's ok on another computer doesn't that prove the 'problem' is somewhere else ?
I don't know what 'label2' is or even if I have one. I've also tried Excel safe mode and a windows XP system restore, nothing made any difference
(although system restore failed).
Any suggestions or help to fix this REALLY appreciated. Has anyone had this error and recovered from it ?
Thanks, ADKM