Results 1 to 3 of 3

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

  1. #1
    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.

  2. #2
    Join Date
    Aug 2011
    Posts
    568

    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.

  3. #3
    Join Date
    Aug 2011
    Posts
    542

    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.

Similar Threads

  1. How to turn off compatibility Checker in Microsoft Excel 2007
    By CeLeStiA in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:20 PM
  2. How to disable compatibility mode in Microsoft Excel 2007
    By AdilShaikh18 in forum MS Office Support
    Replies: 4
    Last Post: 24-01-2012, 04:20 PM
  3. How to turn off Group Mode in Microsoft Excel
    By AlandraJ in forum Windows Software
    Replies: 2
    Last Post: 05-01-2012, 03:37 PM
  4. Pass query in design mode in Access 2007
    By Chandranath in forum Windows Software
    Replies: 5
    Last Post: 08-01-2010, 05:45 AM
  5. Design view table in Microsoft access 2007
    By Balamohan in forum Windows Software
    Replies: 5
    Last Post: 08-01-2010, 03:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •