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_PeallOct 14, 2021Copper ContributorThanks 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).- 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.