View original (French)

Unable to exit creation mode

Solved
edemkossi2 Posted messages 5 Status Member -  
edemkossi2 Posted messages 5 Status Member -
Hello,
I am working on an Excel .xls file (2007 version). This file contains macros and ActiveX controls. Until yesterday, everything was working fine.
When I opened it this morning to make some changes, I got error messages: Unable to exit design mode. The control "commandbutton2" could not be created.

I copied the file to 2 other computers and it works well. When I come back to my computer, the problem recurs, and I'm stuck. I uninstalled Excel and reinstalled it, but that didn't solve the problem.

I have Windows 10 Professional on my ASUS PC. I have gone through all similar posts, but none provide an appropriate solution. I need help....

5 answers

  1.
    edemkossi2 Posted messages 5 Status Member 1
     
    Hello,
    Despite the restoration I did yesterday following your recommendation, the problem has still not been resolved. I ended up formatting and reinstalling the entire system only on the C:\ drive last night, and this morning everything started working correctly, allowing me to make progress on the file. This proves that the file had no issues, but that the problem came from the computer; however, I'm not sure where exactly. I still appreciate your help.

    Let’s hope someone can figure out exactly how to solve this problem without having to format the system...
    1
  2. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    Hello,
    a Windows update that could cause this issue?
    0
    1. edemkossi2 Posted messages 5 Status Member 1
       
      That was my first thought, I went to check the updates, the last one was dated January 6, 2019, but I had worked on the file long after and it was working fine. I still uninstalled that update but it didn't solve the problem.
      0
  3. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Good evening,

    there is a macro with an error and certainly some code in ThisWorkbook, but without seeing your file, it's hard to say more

    --
    See you,
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
    1. edemkossi2 Posted messages 5 Status Member 1
       
      Actually, I don’t think the problem comes from the file since it works perfectly on two other computers. I think the problem lies with the computer, but I don't know if it's the registry or something else. I've even deleted the *.exd files without making any progress.
      0
  4. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,
    you can try a system restore to a date prior to the problem; this restore will put your computer back to the state it was in on the chosen date.

    Press the Windows key on your keyboard (the key symbolized by a window) and the R key at the same time.
    Type rstrui and hit OK.
    Next
    check show more restore points
    select a date prior to the problem
    next, etc...
    just let the computer do its thing, don’t touch anything until it restarts or you have a window notifying you of the restoration status.
    This will take at least fifteen minutes, so be patient and whatever you do, do not touch
    your computer until the operation is completed.

    A+
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
    1. edemkossi2 Posted messages 5 Status Member 1
       
      Hello,
      Despite the restoration I performed yesterday following your recommendation, the problem has still not been resolved. I ended up formatting and reinstalling the entire system only on drive C:\ last night, and this morning everything started working correctly, allowing me to make progress on the file. This proves that the file had no issues, but that it was a problem with the computer; however, I don't know exactly where. Thank you anyway for your help.
      0
  6. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    You can also try to restore your Excel workbook to an earlier date (be careful of the risk of losing the most recently entered data).
    0