Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Menubar missing (Excel 2000)

    How do I restore the menu bar? It has disappeared.

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Menubar missing (Excel 2000)

    Activate the Visual Basic Editor (Alt+F11)
    Activate the Immediate window (Ctrl+G)
    Type Application.CommandBars("Menu Bar").Position = msoBarTop and press Enter
    Switch back to Excel (Alt+F11)
    Do you see the menu bar now?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Menubar missing (Excel 2000)

    The only way (I know of) to get rid of the menubar (the menu bar is the one with File, Edit, View...) is to add a new commandbar as a "menubar" in VB. XL allows only 1 menubar so the original is hidden/inactive. to get it back just delete the new menubar that was created. If the added menubar is named "New Menubar" you would use a line in VB like:
    commandbars("New Menubar").delete

    Once the new one is deleted the original will reappear.

    If it is a toolbar (not a menubar) just go to view - toolbars - customize - toolbars tab and check the one you want visible.

    You can have multiple toolbars (but as I mentioned: only 1 menubar). As far as I know, a menubar (whether the normal, chart or a custom one) must be visible. I do not think it is possible to have no menubar of any kind.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menubar missing (Excel 2000)

    Thanks for the help!

Posting Permissions

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