Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robert
 
Posts: n/a
Default How do I uhide the MENU bar?

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't know what the tutorials did, but you may want to try:

Tools|customize
put a check mark in front of "worksheet menu bar"

If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true

Then back to excel to see if that helped.

Robert wrote:

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc


--

Dave Peterson
  #3   Report Post  
Robert
 
Posts: n/a
Default

Dave Thank you very much for responding to my predicament.
After several attempts and getting frustrated your first suggestion worked
after resetting the "worksheet menu bar"

Back on track, thankyou.

"Dave Peterson" wrote:

I don't know what the tutorials did, but you may want to try:

Tools|customize
put a check mark in front of "worksheet menu bar"

If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true

Then back to excel to see if that helped.

Robert wrote:

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc


--

Dave Peterson

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
What is a shortcut menu? Jeffry Excel Discussion (Misc queries) 4 May 4th 09 04:03 PM
Help with drop down menu Jrr6415sun Excel Worksheet Functions 4 July 10th 05 05:58 PM
Excel Menu Problem RONGGGG Excel Discussion (Misc queries) 4 June 13th 05 08:17 PM
What is a Conditional pull down menu? Neil Bhandar Excel Discussion (Misc queries) 2 May 3rd 05 02:55 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"