Forum Discussion
Jon_Peall
Oct 14, 2021Copper Contributor
Excel 365 stuck in Design mode
I've been using same spreadsheet for several months but suddenly cannot escape from Design mode -button on Developer tab has no effect although it does change colour. Any thoughts welcome.
JKPieterse
Oct 14, 2021Silver Contributor
What happens if you insert a new control on the sheet?
Jon_Peall
Oct 14, 2021Copper Contributor
Thanks Jan
The new control works fine, but the existing ones can't be operated. When you hover over them they still show the 4-headed selection arrows. When I select Properties it shows the worksheet properties whichever control is selected (whether in Design mode or not).
The new control works fine, but the existing ones can't be operated. When you hover over them they still show the 4-headed selection arrows. When I select Properties it shows the worksheet properties whichever control is selected (whether in Design mode or not).
- JKPieterseOct 14, 2021Silver ContributorThis sounds like they are broken. One thing you could try: Close Excel. Then look in your temporary folders for any files with the exd extension. Delete all of them.
Tip: Press the Windows key and type run and press Enter. Then type %temp% and hit OK to directly open your temp folder.- Jon_PeallOct 14, 2021Copper ContributorThanks Jan. I tried that, but there are none -only when Excel is open.
- JKPieterseOct 15, 2021Silver ContributorIn that case I suspect a file corruption is the cause, which means you likely have to re-do the controls on the sheets. Does your VBA project have any missing references?