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

Thread: Can't exit design mode because Control "C60' can not be created

  1. #1
    New Member
    Join Date
    May 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can't exit design mode because Control "C60' can not be created

    Hello,
    BACKGROUND: I wrote an excel workbook that allows users to enter/maintain personnel data. It gets updated daily at 5 different work locations. The locations use the file to manage their specific personnel. It generates an attendance sheet and also a work summary sheet. They basically take the file for yesterday, make updates and save it for the new day. It serves as a plan for tomorrow and a record of yesterday. Personnel can be added/deleted and trucks change locations so the list is dynamic. We also have clerks that access the file to take care of the attendance sheet. They save the file as well. The excel files are saved on a network location in different files.

    The work entry page utilizes about 100 activex combo boxes to select individuals and their vehicles to fill in the daily work summary sheet. The comboboxes listfillrange refers to a separate hidden page that has personnel names and trucks that are forced into alphabetical/numerical order by formulas.

    I chose activex comboboxes because the list rows can be bigger (45 personnel), and the linked call allows the users to easily make wholesale changes to the schedule and makes the data entry very user friendly...auto complete and on and on.

    PROBLEM: What is specifically happening...I save the file to the network location. A clerk accesses the file, make some changes and saves those changes. I go back in and access the file to make a file for the next day and it works fine. I save it, close it and we are all set. If I have to access the file again, I get "Can't exit design mode because Control "C60' can not be created" and the comboboxes have all been renamed. C60 is the name of one of the comboboxes. The clerk that was in the file earlier can access it and it works fine...no error message and comboboxes not renamed.

    It affects some users and not others. I have renamed all of the comboboxes to unique names. All the other controls in the workbook are form controls. I have made sure all are saving as .xlsm. I have checked the trust center and observed what the users do when they access and save the file. Nothing of note. I have tried deleting the tmp files from the december 2014 issue that affected activex. At a loss.

    Trying to roll this out on a large scale but won't until I get this glitch fixed. I need multiple users to have access and I really want to keep the activex comboboxes. I can do one time fixes, but can't sustain going back day after day to do that. HELLLLPPPPPP!!!!

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    9,977
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    and the comboboxes have all been renamed
    To what names?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    New Member
    Join Date
    May 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    To the default excel combobox name. (ex. ComboBox123). One occasion it was ComboBox1. Another time it was ComboBox327. I had read somewhere that you should always come up with your own names for ComboBoxes...never use the excel default. So, I changed the names to the coincide with the cell the box was over. C12, C13, E15 etc. Didn't help. When I click on a combobox, view it's code, the drop down of all available comboboxes lists a bunch of new ones in the default format and none of the ones I named are listed.

  4. #4
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    9,977
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    How exactly are you changing the name?
    BTW, the only reason I know of to change the default name is to make it more recognisable to yourself. I haven't seen any technical issues with keeping the default name.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  5. #5
    New Member
    Join Date
    May 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    Quote Originally Posted by MARK858 View Post
    How exactly are you changing the name?
    BTW, the only reason I know of to change the default name is to make it more recognisable to yourself. I haven't seen any technical issues with keeping the default name.
    I changed it in each ComboBox Properties menu. That didn't fix the problem, but it did help me distinguish a ComboBox that I renamed vs on that excel used the default on.

  6. #6
    New Member
    Join Date
    May 2017
    Location
    Minnesota
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    0down vote
    There is a very simple fix for this issue:

    1. Close all Excel documents
    2. Open a blank document
    3. Excel options > Trust center settings>macro settings>Select{Disable all macros with notifications}
    4. Active X settings >
      Select either:
      • Disable all controls without notifications
      • Prompt me before enabling all controls with minimal restrictions

    Apply all settings and close.
    Open the affected file and check allow the prompt to enable macros if required.
    Last edited by Joe4; May 15th, 2017 at 09:31 AM.

  7. #7
    New Member
    Join Date
    May 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    Quote Originally Posted by proweb365 View Post
    0down vote
    There is a very simple fix for this issue:

    1. Close all Excel documents
    2. Open a blank document
    3. Excel options > Trust center settings>macro settings>Select{Disable all macros with notifications}
    4. Active X settings >
      Select either:
      • Disable all controls without notifications
      • Prompt me before enabling all controls with minimal restrictions

    Apply all settings and close.
    Open the affected file and check allow the prompt to enable macros if required.
    So I tried this. The macro settings choices are all greyed out with the selection being "Enable all macros." The activeX settings was already on "Prompt me before enabling all controls with minimal restrictions." Thoughts?

  8. #8
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    32,490
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Can't exit design mode because Control "C60' can not be created

    It sounds to me like you're running into an issue with an update to one of your systems, similar to this problem from a couple of years ago - Office Update breaks ActiveX controls | Excel Matters

Some videos you may like

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
  •