Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Turn on and off Design mode in Microsoft Excel 2007

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-01-2012
Member
 
Join Date: Nov 2011
Posts: 120
How to Turn on and off Design mode in Microsoft Excel 2007

I need a bit help to enable and disable design mode in Microsoft Excel 2007. I am not finding a exact and easy way to do that. If there are automated settings also then that will be of great help.

Reply With Quote
  #2  
Old 05-01-2012
Member
 
Join Date: Aug 2011
Posts: 559
Re: How to Turn on and off Design mode in Microsoft Excel 2007

You'll need to first enable the Developer Tab on the Ribbon. Then click on 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. To get into the design view you hide the "Control Toolbox" toolbar, and choose a design mode.
Reply With Quote
  #3  
Old 05-01-2012
Member
 
Join Date: Aug 2011
Posts: 534
Re: How to Turn on and off Design mode in Microsoft Excel 2007

First remove workbook protection and sheet protection. That you can use the menu bar, menu "Tools-protection" solve (if it is visible). If the menu bar is not visible, please change via Alt + F11 in the VBA Editor (press ENTER to confirm each) there in the direct area (Ctrl + G) and then enter the following commands:
  • Application.Commandbars.Activemenubar.enabled = true
  • Application.Commandbars.Activemenubar.visible = true
Changer then back to EXCEL. via View > Toolbars > Customize or right click in the menu bar and choose Customize. On the toolbar Control Toolbox one. There you can activate the design mode, with which you can click on the icon (right-click), without the stored hyperlinks or VBA code to run. Now you can also change the icons, or rename the VBA-/Makro-Code view and modify. From the Panel go on Tools-Options > View sheet tabs one to be able to switch to other worksheets. Possibly the other sheets are hidden, you can it via the Format - Sheet" unhide, or by using VBA you the property Visible" of the leaves to "-1 - xlSheetVisible.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Turn on and off Design mode in Microsoft Excel 2007"
Thread Thread Starter Forum Replies Last Post
How to turn off compatibility Checker in Microsoft Excel 2007 CeLeStiA MS Office Support 2 21-02-2012 01:20 PM
How to disable compatibility mode in Microsoft Excel 2007 AdilShaikh18 MS Office Support 4 24-01-2012 04:20 PM
How to turn off Group Mode in Microsoft Excel AlandraJ Windows Software 2 05-01-2012 03:37 PM
Pass query in design mode in Access 2007 Chandranath Windows Software 5 08-01-2010 05:45 AM
Design view table in Microsoft access 2007 Balamohan Windows Software 5 08-01-2010 03:41 AM


All times are GMT +5.5. The time now is 11:57 PM.