how do I turn on/off "Design mode" in Excel 2007

E

Elkar

You'll need to first enable the Developer Tab on the Ribbon.

Click the Office Button (big, round button located at top-left)
Click the "Excel Options" button
On the Popular Tab, check "Show Developer tab in the Ribbon"
Click OK

You'll now be able to select the Developer Tab, and toggle Design Mode
on/off from there.

HTH,
Elkar
 
Top