Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do I turn on/off "Design mode" in Excel 2007

how do I turn on/off "Design mode" in Excel 2007
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how do I turn on/off "Design mode" in Excel 2007

To turn on/off "Design mode" in Excel 2007, follow these steps:
  1. Open the Excel workbook that you want to work with.
  2. Click on the "Developer" tab in the ribbon. If you don't see the "Developer" tab, you may need to enable it by going to "Excel Options" "Popular" "Show Developer tab in the Ribbon".
  3. In the "Controls" group, click on the "Design Mode" button. This will turn on "Design mode" and allow you to edit or add controls to your worksheet.
  4. To turn off "Design mode", simply click on the "Design Mode" button again. This will disable "Design mode" and allow you to use the controls that you have added to your worksheet.

Note that "Design mode" is only available if you have added controls to your worksheet using the "Developer" tab. If you haven't added any controls, the "Design mode" button will be disabled.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default how do I turn on/off "Design mode" in Excel 2007

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


"easybuild" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mkae Mode function return "" instead of #N/A when there is no Mode Tonso Excel Discussion (Misc queries) 2 March 10th 07 06:10 PM
Error Msg "Can't Exit Design Mode" chad Excel Discussion (Misc queries) 0 February 8th 07 11:00 PM
Excel 2007 and "Compatibility Mode" Chaplain Doug Excel Discussion (Misc queries) 2 February 6th 07 05:45 PM
Make "Edit" mode default, rather than "Enter"? Greg Boettcher Excel Discussion (Misc queries) 1 July 27th 06 01:46 AM
how to turn off design mode Paul Excel Worksheet Functions 2 September 23rd 05 01:10 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"