Forum Discussion
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.
I had the same problem. It turned out that the control (a pushbutton) did not have a macro assigned. As soon as I assigned a macro it worked. Check to make sure the assigned macro is still attached to the control.