Email:      Pass:    Pass?
Advertisements


Free Excel Forum

How Do I Get My Menu Bar Back?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I've lost my menu bar in Excel. I tried to enable Worksheet Menu bar, but
that is not even listed in my toolbar section in the Customize box. Any
other ideas?



Similar Excel Video Tutorials

Helpful Excel Macros

Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows yo
Print The Current Worksheet in Excel
- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are currentl
Print Selected Worksheets in Excel
- This free excel macro will print all selected worksheets in Excel. If there are no other worksheets selected the active
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Display or Show all of the Comments within an Entire Excel Workbook
- This macro in Excel will display all of the comments within the entire Excel workbook. This means that all of the comme

Similar Topics







Having a bad year here already. Two things -

I lost my EDIT menu on my menu bar! Now it goes FILE VIEW INSERT FORMAT .... Tried resetting everything. I lost my customs icons when I did that, but my edit menu never came back.

What I was doing was fooling around with the Customize menu trying to find CLEAR ALL so that I can put it on one of my toobars.

Help with both issues would be appreciated!!!!!


How do I make Excel-document load up without menu-bar?

Also, when I have my Excel-document open in full-screen, with the menu-bar visible, then if I do the following steps:

1.Right click on the menu-bar.
2. Select 'Customize' in the bottom.
3. In the toolbar-tab, also at the bottom there is a checkbox saying 'Worksheet Menu Bar'.

...now when I uncheck this, the toolbar disappears but here is the issue:
When I click Close the toolbar, re-appears by itself!

Any solutions to this guys?


The file menu has mysteriously disappeared from the menu bar in Word 2003
(Student and Teacher edition). Is there any way to get it back? I've tried
both View>Toolbars>Customize and Tools>Customize.



Please help me replace the entire edit menu. i have tried customize | options 'reset menu and toolbar usage' and that doesnt put it back. It cant be dragged back on like the submenu's can.

I'm sure theres a way, just cant find it yet.


When customizing a toolbar, a tried to create a button for Goal Seek by
dragging it from the menu to to the toolbar. At that point it disappeared
completely, appearing on neither the toolbar nor the menu. Using the "Reset
menu and toolbar usage data" button under customize has failed to bring it
back, and I have no way to use the Goal seek function now.

I created buttons in this way with the "Hide rows" menu choice successfully
in the past. Unfortunately, they have disappeared completely now as well
when I tried to use the "Reset menu and toolbar usage data" button. I cannot
hide rows as this action is completely gone (off the menu as well).
Aaaahhhh! Help! Thanks.



Hi,

I want to disable or hide the right click short cut menu when I right click on toolbar which gives ability to add formatting toolbars etc....... til customize.

When I create my own custimize tool bar on the bottom right side excel creates a small arrow which let me go to customize the toolbar options.

Is there any way I can hide that option while creating my own customize toolbar?

Thanks for your help.

Regards,


Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks




Easy I'm sure, but for a novice - I can't do it

I can add a new 'menu' to my toolbar in my worksheet using
Tools-Customize-Commands and drag/drop new menu button, but how do I add a
list to it so that the user can chose a subject from that 'menu' and a
seperate worksheet is then opened for that chosen subject

plain English please !!

Many thanks



How can I re-arrange Worksheet Menu-Bar. Recently I added an Add-In. This add-in is now displayed on the last spot on Worksheet Menu bar. The problem is the last spot used to be "Help" but now "Help" is secondlast on the Toolbar menu. How I can re-arrange the Worksheet Menu Tool-Bar?

For example, if I like to bring File (on Workseet Menu Toolbar)from First place to the 3rd place.

Any help will be appreciated.


Hi Group,

Is it possible to enable a single toolbar button OR menu option from a Menu or Toolbar if I protect the Toolbar or Menu?

For Exp: I protect the Formatting Toolbar completely in my project but at later stage I only want to enable 'Merge Cells' button (rest all should remain disabled). Is it possible if yes please give me an idea or a peice of code .

Regards,
Gajendra Gupta


A spreadsheet that needs a new menu item in a custom menu does not show the custom menu code. Tools-->Customize-->Commands-->Rearrange Commands shows the menu and allows me to add a new menu item and macro.
After saving and exiting excel and going back into the spreadsheet, the new menu item is gone. How can I find the code to do this to keep the menu item? In the VBE, I looked in the object browser(F2) in all of the libraries and could not find the code. In the workbook_open and workbook_activate I can disable it with CommandBars("Worksheet Menu Bar").Controls("menu").Delete and it disappears. Any help on this would be great.


I have created a help menu and the button on the toolbar to open the help menu with the code below:

"Private Sub CommandButton1_Click()
Application.Help "C:\RSystems Help\Help Documents\help menu.html", 0
End Sub"

This works fine but I want to link the help file to bring up a specific section of the help menu depending on which excel sheet you have up. For example instead of opening the help menu at the introduction I want to open it at another section. Is there a way of doing this?


I have been trying to run a Macro attached to a new Menu or a new toolbar. My problem is that when I takes this File to other PC, the menu or toolbar disappear. Is there any way to save the new Menu or toolbar with the Workbook.

Thanks in advance


Just curious as to what could make a custom menu or custom button disappear from Excel upon opening it.

I had created a custom menu with personal.xls macros in it for someone here a while back, and today it was completely missing.. although the Personal.xls folder still existed with the macros.

I am quite sure that they did not manually remove the menu by right-clicking and selecting Customize and dragging back the menu items...

Thanks.


Hi, I've created a custom menu that appears on the main toolbar when all of my sheets are active. One of the actions on that menu creates an embedded chart in worksheet 2. However, whenever I select the chart, I lose my custom menu. When something else is selected (e.g. another section of worksheet 2 or any of the other worksheets) my menu reappears. Would anyone know how I can preserve my menu when my chart is selected. Thank you very much.


Hi All,

While working on a macro I had to made my File menu invisible by Application.CommandBars("File").Visible = False. After completing my task I made my File Menu again vishible by making the same condition True.

However, in the process I have lost my access Key (Alt +F). Now I don't see the underscore below the letter "F" in my File menu nor Alt+F opens my File menu.

How can I bring my "File" menu to be accessed by Alt+F.


Many thanks in advance.

Rgds, Kaushal


All,

I am using Excel as front end in my application and using Excel interface for communication between excel and my ATL COM components, As part of it, i need to enable Undo / Redo Operation from my components depending on the user
operations.

I'm able to enable the undo (both menu & toolbar) through raw_OnUndo()
method present in _Application interface,also i found one more method
raw_OnRepeat() which would enable Repeat Menu alone , but i'm not able to
find any method for enabling Redo options.

Can Some one suggest how to enable redo menu & toolbar icon.

Thanks in Advance,
S.Annamalai


I cannot find my worksheet menu bar.
When I tried: right clicking on a tool bar clicking customize in the
drop down menu and in the new customize pop up box put a check and clicked
Reset - it still would not work.
I need Help.
Any Help is Appreciated




Hi all

The menu bar has changed from the standard menu functions to what
appears to be chart funtions. I have file, edit, view, insert, format,
tools, chart, window, help. I have lost the Data menu function and
most of the functions under Insert and format.
I have tried to reset the toolbar as well as uninstalling and
reinstalling Excel with no luck.


Thanks for advise




Hello,

I was trying to learn how to build custom menu bars on excel. In the process I removed several existing pulldown menus. I.e. View, Insert, and Help are gone. I cannot figure how to reset Excel to get back those menus. I have been in the help menu, and tried to reset the menu bar through Tools-customize-reset.

Any suggestions


I want to add a new top level entry on the Main Menu that will run a
macro. Doing so should allow me to have a menu with the new entry each
time I open Excel. I've done this before under Excel 97 but when I try
to do it under 2003 I run into the following problem

I right click on the Main Menu and choose Customize. I then select
Macro from Categories and drag a Custom Menu Item from Commands to the
menu. I then rename it and assign a macro. At least, I believe this is
the way I did it under 97 years ago.

The menu item works just as expected.

However, when I exit Excel and then open Excel again, the recently added
menu item appears briefly but disappears shortly and the menu is as it
was before I changed it.

Can someone suggest what I might being doing wrong?

Thank you.





I made an application in Office2003, with a customised toolbar.
Now, this application is translated to Office2007.
I can find back my toolbar as an add in and it is working fine.

But ... for some buttons of my toolbar / menu items,
there is a wrong/no macro attached.
I find no possibility in order to link another macro to the menu buttons.

How can I change that customised toolbar ?

thx


I have removed some of the menu options on my menu bar such as Format, Data Tools, help and such.

I am now trying to put them back on. I am going to "Customize" and doing it, but it keeps disappearing as soon as I close it.

I am sure this is so simple. Just not today,,,, for me....

Please help.

cp


I have created a new menu-bar for a spreadsheet application I have designed.
The menu looks great on the front page, however what I would really want is on subsequent sheets for the menu to be minimised and replaced by a small box saying something like "Menu", which would then call the menu-bar again. I can do the boxes etc, and code to reactivate the menu-bar but not sure of the code I could use to alter the position of the menu-bar on the screen.

Any ideas folks ?

Thanks


How can I add buttons to the short cut menu. Microsoft Help page tells me to go to View--> Toolbars --> Customize --> Short Cut Menu... except Short Cut Menu is not in the list of choices...

I just want to add Paste Values and Paste Formatting to the right click menu.