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

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Posts
    1,331
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

     
    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

  2. #2
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    19,737
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help! It's all turned to custard...


  3. #3
    Board Regular
    Join Date
    Jul 2009
    Posts
    1,331
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help! It's all turned to custard...

    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 ?

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Help! It's all turned to custard...

      
    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.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com