Unable to exit creation mode

Solved
edemkossi2 Posted messages 5 Status Membre -  
edemkossi2 Posted messages 5 Status Membre -
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 réponses

edemkossi2 Posted messages 5 Status Membre 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
Yoyo01000 Posted messages 1720 Registration date   Status Membre Last intervention   168
 
Hello,
a Windows update that could cause this issue?
0
edemkossi2 Posted messages 5 Status Membre 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
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
edemkossi2 Posted messages 5 Status Membre 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
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
edemkossi2 Posted messages 5 Status Membre 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
Yoyo01000 Posted messages 1720 Registration date   Status Membre 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