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

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.
"Trevor" wrote:

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

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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

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".

"Gord Dibben" wrote:

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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

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

"JLatham" wrote:

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".

"Gord Dibben" wrote:

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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

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" wrote:

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

"JLatham" wrote:

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".

"Gord Dibben" wrote:

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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

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

"Trevor" wrote:

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

"JLatham" wrote:

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".

"Gord Dibben" wrote:

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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

Hi Gord

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



"Gord Dibben" wrote:

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

On Sun, 6 May 2007 22:09:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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.
"Trevor" wrote:

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