how do i get the menu bar to be displayed ?

[Trevor]

how do i get the manu bar to show up on the top of the screen. ?

 

[JLatham]

I hope you mean that it has just moved either to one side or the other of the
window or perhaps to the bottom or center?

If it is at one of the edges of the Excel window, look for the little set of
3 dots at top/left edge of it. Move your mouse over those and it should
change to a 4-headed arrow symbol. Click and drag the menu to where you want
it.

If the menu is out in the middle of the Excel window - click on the title
bar and drag it to where you want it.

I don't think there's any way to not display it (I could be wrong), but I
believe the basic Menu bar is an "indestructible" part of the Excel window
itself.

If you are talking about anything other than the Menu bar with the words
"File Edit ..." etc. in it, then you can bring other toolbars into view by
using View | Toolbars from the (word) menu and select which other toolbars
you'd like to see.

 

[Gord Dibben]

Perhaps someone used VBA code to hide it?

Try this toggle macro.

Sub Worksheet_Menu_Hide()
If Application.CommandBars("Worksheet Menu Bar").Enabled = True Then
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Else
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End If
End Sub


Gord Dibben MS Excel MVP

 

[JLatham]

Darned good thing I qualified my statement! Always something new to learn -
and a reminder of "just because I haven't done it, doesn't mean it can't be
done".

 

[Trevor]

Hi JLatham..
all my spreadsheets including "new" spreadsheets are only showing just the
blue bar...nothing else !!!

what i did initially was to re-customise the spreadsheet i was working on
...so i dragged all the items from the top of the spreadsheet to the toolbox
pop up window, including the menu barhence lost it.


do you want me to cut and paste the problem

CHEERS
TREVOR

 

[Trevor]

Hi Gord

Only I use my computer...and i dont use VBA
Perhaps the best solution is to reload the software
Cheers Trevor

 

[JLatham]

Look at Gord Dibben's post above. He has code that may get you out of this
situation - To get his code to where you can use it, open Excel and then
press [Alt]+[F11] at the same time. The VB Editor will open, It should
still have its menu in one piece and visible. Click Insert then choose
Module. Cut and paste his code into the module that appears (big white area
in what was big gray area). Click anywhere inside of the code you just
pasted into the module and press the [F5] key - that causes the code to run.
Hopefully at that point your regular Excel menu bar will be visible again.

Post back if it is not, and also tell us which version of Excel you're using.

 

[Trevor]

Hi
thanks ever so much for the help u have given..I reloaded the excel software
go get round the problem...as I needed to do some urgent work...Once again
thanks..It was the first time I have used the internet for this type of help

Cheers
Trev

Look at Gord Dibben's post above. He has code that may get you out of this
situation - To get his code to where you can use it, open Excel and then
press [Alt]+[F11] at the same time. The VB Editor will open, It should
still have its menu in one piece and visible. Click Insert then choose
Module. Cut and paste his code into the module that appears (big white area
in what was big gray area). Click anywhere inside of the code you just
pasted into the module and press the [F5] key - that causes the code to run.
Hopefully at that point your regular Excel menu bar will be visible again.

Post back if it is not, and also tell us which version of Excel you're using.

Hi JLatham..
all my spreadsheets including "new" spreadsheets are only showing just the
blue bar...nothing else !!!

what i did initially was to re-customise the spreadsheet i was working on
..so i dragged all the items from the top of the spreadsheet to the toolbox
pop up window, including the menu barhence lost it.


do you want me to cut and paste the problem

CHEERS
TREVOR

 

[Trevor]

I reloaded excel and it worked ....but its back again....NO MENU BAR !!!

 

[Tree]

I have had this same problem for a few months now and had lost my original
installation disk so I could not reinstall. I have been going out of my
"tree" trying to find the solution. I followed the instructions given by
Jlatham which was key and used the code from Gord Dibben and just like that
my problem was solved. Thank you so much!!!

Look at Gord Dibben's post above. He has code that may get you out of this
situation - To get his code to where you can use it, open Excel and then
press [Alt]+[F11] at the same time. The VB Editor will open, It should
still have its menu in one piece and visible. Click Insert then choose
Module. Cut and paste his code into the module that appears (big white area
in what was big gray area). Click anywhere inside of the code you just
pasted into the module and press the [F5] key - that causes the code to run.
Hopefully at that point your regular Excel menu bar will be visible again.

Post back if it is not, and also tell us which version of Excel you're using.

Hi JLatham..
all my spreadsheets including "new" spreadsheets are only showing just the
blue bar...nothing else !!!

what i did initially was to re-customise the spreadsheet i was working on
..so i dragged all the items from the top of the spreadsheet to the toolbox
pop up window, including the menu barhence lost it.


do you want me to cut and paste the problem

CHEERS
TREVOR