Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 75
Default Unhide Main Menu Bar

Another person here wrote a macro which hides Excel's Main Menu Bar. Is there
a non-programming way to unhide the main menu bar?

I've tried using Alt-T to get to the Tools menu on the main bar but,
seemingly, if the main menu bar isn't visible, Alt-T doesn't work.

This little gift from the macro writer has now "infected" a few machines.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Unhide Main Menu Bar

You could right-click anywhere in the remaining toolbars, and choose
Customize, select the Toolbars tab, and hit the Reset button.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dkline" wrote in message
...
Another person here wrote a macro which hides Excel's Main Menu Bar. Is

there
a non-programming way to unhide the main menu bar?

I've tried using Alt-T to get to the Tools menu on the main bar but,
seemingly, if the main menu bar isn't visible, Alt-T doesn't work.

This little gift from the macro writer has now "infected" a few machines.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Unhide Main Menu Bar

Bob

I find that if Worksheet Menu Bar has been disabled it will not show up in the
CustomizeToolbars dialog so can't be reset.

Application.CommandBars("Worksheet Menu Bar").Enabled = False

needs the following to become enable again

Application.CommandBars("Worksheet Menu Bar").Enabled = True

Any other method?

Gord

On Fri, 2 Feb 2007 10:44:41 -0000, "Bob Phillips" wrote:

You could right-click anywhere in the remaining toolbars, and choose
Customize, select the Toolbars tab, and hit the Reset button.


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
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
keep new menu item with workbook Andy G. Excel Discussion (Misc queries) 1 May 16th 06 08:09 PM
Main menu is missing Deb G Excel Discussion (Misc queries) 3 May 10th 05 07:46 PM
drop down menu containing worksheet names J-Rad Excel Worksheet Functions 3 February 1st 05 03:25 AM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 08:39 PM


All times are GMT +1. The time now is 12:43 AM.

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"