Results 1 to 3 of 3

Hide/Show Menus/Tool Bars- Hides Tabs

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    Dallas, TX
    MS-Off Ver
    365 PC and Mac
    Posts
    64

    Hide/Show Menus/Tool Bars- Hides Tabs

    Hello- I'm trying to get excel to hide my menu bar and all the tabs in Excel 2003. To do so, I'm using the following VBA:


    On Error Resume Next
            With Application
               .DisplayFullScreen = True
               .CommandBars("Full Screen").Visible = False
               .CommandBars("MyToolbar").Enabled = True
               .CommandBars("MyToolbar").Visible = True
               .CommandBars("Worksheet Menu Bar").Enabled = False
            End With
    On Error GoTo 0
    The problem is that when I active this, excel grows beyond the bottom of my screen and I can't see the tabs at the bottom of the workbook.

    Any advice?
    Thanks!
    Last edited by MrBill; 10-14-2010 at 12:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1