cannot exit Developer Design mode

robertvdb

Active Member
Joined
Jan 10, 2021
Messages
334
Office Version
  1. 2016
Platform
  1. Windows
I am using Excel 365. I can't exit the Developer design mode, so when I click on the buttons nothing happens. Who can help ?
 

Attachments

  • Untitled.png
    Untitled.png
    52.3 KB · Views: 21

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You're not in design mode, which is why you can't exit it.

I'd say that either that's a Form control, not activex, or you've run into one of the most common issues with activex controls, where the version of the form library on your computer is different to the one used to create that control. In that case, you need to close office applications, and locate and delete any .exd file (temp files that are created for activex).
 
Upvote 0
Thanks Rory

the file was created on the same PC where I'm using it, so this cannot be the cause. Also, no .exd file has been found.

Anyhow, I was able to solve it by creating a new file, and transferring all the data and code to the new file. Took me some 15 minutes.

Still a mystery, but I've been working around it.
Cheers
Ralph
 
Upvote 0
Solution
If there are no .exd files, then that is not an activex control - assuming you searched in hidden folders for the .exd files.
 
Upvote 0

Forum statistics

Threads
1,221,825
Messages
6,162,165
Members
451,750
Latest member
dofrancis

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