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.
In 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?
I don't think so Jan. I have added a reference to Microsoft Office 16.0 object library, but that is still ticked. So I guess I'll have to add the controls back.
Many thanks for thinking about it.
Many thanks for thinking about it.