oops, how do i get the excel text-menu back?
 

i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

It's called the "Worksheet Menu Bar". Right click your toolbar and
click "customize...". Go down to worksheet menu bar and make sure it
is selected. If it isn't, select it. If it is, you should reset it.

Cheers,
Jason Lepack

mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

Right click on any toolbar, and click customize. In the Toolbars tab
check off "Worksheet Menu Bar", then click ok.


Sandy
mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

worksheet menubar isnt in the list



"Jason Lepack" wrote in message
ps.com...
It's called the "Worksheet Menu Bar". Right click your toolbar and
click "customize...". Go down to worksheet menu bar and make sure it
is selected. If it isn't, select it. If it is, you should reset it.

Cheers,
Jason Lepack

mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

worksheet menu bar isnt in the list


"Sandy" wrote in message
oups.com...
Right click on any toolbar, and click customize. In the Toolbars tab
check off "Worksheet Menu Bar", then click ok.


Sandy
mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

Try using this code to re-enable it

Sub EnableBar()
Application.CommandBars("Worksheet Menu Bar") _
..Enabled = True
End Sub

Open VBE (alt + F8)
Insert a Module
Then Run code

If the bar does not reappear then try my previous post agin and see if
it is in the list. Let me know how it worked out.

Sandy

mpg wrote:
worksheet menubar isnt in the list



"Jason Lepack" wrote in message
ps.com...
It's called the "Worksheet Menu Bar". Right click your toolbar and
click "customize...". Go down to worksheet menu bar and make sure it
is selected. If it isn't, select it. If it is, you should reset it.

Cheers,
Jason Lepack

mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

Sorry made a mistake...it happens.

To open VBE use alt+F11.

To run the code use Alt+F8 and select EnableBar and click Run


Sandy
mpg wrote:
worksheet menu bar isnt in the list


"Sandy" wrote in message
oups.com...
Right click on any toolbar, and click customize. In the Toolbars tab
check off "Worksheet Menu Bar", then click ok.


Sandy
mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

thanks folks, i have it back now.
whew....


"Sandy" wrote in message
ups.com...
Sorry made a mistake...it happens.

To open VBE use alt+F11.

To run the code use Alt+F8 and select EnableBar and click Run


Sandy
mpg wrote:
worksheet menu bar isnt in the list


"Sandy" wrote in message
oups.com...
Right click on any toolbar, and click customize. In the Toolbars tab
check off "Worksheet Menu Bar", then click ok.


Sandy
mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top
is
gone.

thanks
mg

oops, how do i get the excel text-menu back?
 

thanks folks, i have it back now.
whew....


"Sandy" wrote in message
ps.com...
Try using this code to re-enable it

Sub EnableBar()
Application.CommandBars("Worksheet Menu Bar") _
.Enabled = True
End Sub

Open VBE (alt + F8)
Insert a Module
Then Run code

If the bar does not reappear then try my previous post agin and see if
it is in the list. Let me know how it worked out.

Sandy

mpg wrote:
worksheet menubar isnt in the list



"Jason Lepack" wrote in message
ps.com...
It's called the "Worksheet Menu Bar". Right click your toolbar and
click "customize...". Go down to worksheet menu bar and make sure it
is selected. If it isn't, select it. If it is, you should reset it.

Cheers,
Jason Lepack

mpg wrote:
i have somehow removed the 'text' portion of my excel menu.
'file-open-help-etc...." i was experimenting with commandbars and cant
seem
to get it back.
i have the commandbars all visible again, but the main text at the top
is
gone.

thanks
mg