Help! It's all turned to custard...

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,835
Office Version
  1. 2019
  2. 2016
Platform
  1. 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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hi Shg, Just realised I didn't specified I'm using Office 2003. (The xls file does run OK under Office 2007, and 2003 on a different machine).

I've also been informed "The fundamental problem is that VBA is considered a common feature by Windows, so once it has been installed it is very hard to remove or replace. Uninstalling Office will not remove VBA, and reinstalling Office won't replace the files with the same version that are already there, so you have to either install a newer version or delete everything and reinstall everything."

This suggests I think, a reinstall of Windows, and Office from a new Hard drive ?
 
Upvote 0
Maybe there is something in the workbook open code causing the problem..
If you open the file via windows explorer and hold down the SHIFT key... while opening the file.
See if that gets you into the file.....then you could / should be able to exit the design mode.
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,700
Members
448,293
Latest member
jin kazuya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top