 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008how do i get the menu bar to be displayed ?
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. > 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 >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? [quoted text clipped - 17 lines] > >> 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". > Perhaps someone used VBA code to hide it? > [quoted text clipped - 31 lines] > > > >> 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 > 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 [quoted text clipped - 35 lines] > > > > > >> 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. > Hi JLatham.. > all my spreadsheets including "new" spreadsheets are only showing just the [quoted text clipped - 48 lines] > > > > > > > >> how do i get the manu bar to show up on the top of the screen. ? 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 [quoted text clipped - 59 lines] > > > > > > > > > >> how do i get the manu bar to show up on the top of the screen. ? 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 [quoted text clipped - 59 lines] > > > > > > > > > >> 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 !!! > Hi JLatham.. > all my spreadsheets including "new" spreadsheets are only showing just the [quoted text clipped - 48 lines] > > > > > > > >> 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 > Perhaps someone used VBA code to hide it? > [quoted text clipped - 31 lines] > > > >> how do i get the manu bar to show up on the top of the screen. ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.