| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to bring back the normal menu? | Excel Discussion (Misc queries) | |||
| How do I get "tools" back into the menu in 2003 Excel? | Excel Discussion (Misc queries) | |||
| How do i put back my excel worksheet menu bar | Excel Worksheet Functions | |||
| how do i get my menu bar back? | Excel Discussion (Misc queries) | |||
| How to get back lost Menu | Excel Programming | |||
Hybrid Mode
