If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
unhide menu bar in excel - just disappeared
I have been working in Excel 2003 and the menu bar and the right hand mouse
functions have all disapperaed, I can't find any help to get them back |
#2
|
|||
|
|||
unhide menu bar in excel - just disappeared
Hello Sean,
Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#3
|
|||
|
|||
unhide menu bar in excel - just disappeared
Zack,
There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#4
|
|||
|
|||
unhide menu bar in excel - just disappeared
Sean
Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#5
|
|||
|
|||
unhide menu bar in excel - just disappeared
Gord,
That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#6
|
|||
|
|||
unhide menu bar in excel - just disappeared
Sean
For the row right-click try this line Application.CommandBars("row").Enabled = True For columns use "column" Gord On Sat, 3 Dec 2005 00:13:02 -0800, "Sean" wrote: Gord, That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#7
|
|||
|
|||
unhide menu bar in excel - just disappeared
Gord,
Is there any way of keeping this so it opens correctly every time I open Excel. All this commands work but when I close Excel down all the changes revert back to as it was before with out menu bar or right hand mouse options. When I have got it back and in excel is there any options I need to choose to make it permanent. I have deinstalled office and reinstalled it today, so is this a registery setting. "Gord Dibben" wrote: Sean For the row right-click try this line Application.CommandBars("row").Enabled = True For columns use "column" Gord On Sat, 3 Dec 2005 00:13:02 -0800, "Sean" wrote: Gord, That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#8
|
|||
|
|||
unhide menu bar in excel - just disappeared
Sean
You have an add-in or your Personal.xls opening with some workbook_open or auto_open code that disables these items. Hit ALT + F11 to see what workbooks/projects are showing up in the Project Explorer. Maybe one in there with some code. Go to ToolsAdd-ins and see what you have checked in there. You may have to uncheck all the add-ins then start Excel and add them back one at a time until you find the one that is doing the deed. Currently, do you see Personal.xls in WindowUnhide? There are a couple of other options. Check out your XLSTART folder for files that may be opening hidden. C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART In ToolsOptionsGeneral do you have a path in "At startup, only all files in"? If so, delete that path. After you have a look around post back with the results. Gord On Sat, 3 Dec 2005 12:23:01 -0800, "Sean" wrote: Gord, Is there any way of keeping this so it opens correctly every time I open Excel. All this commands work but when I close Excel down all the changes revert back to as it was before with out menu bar or right hand mouse options. When I have got it back and in excel is there any options I need to choose to make it permanent. I have deinstalled office and reinstalled it today, so is this a registery setting. "Gord Dibben" wrote: Sean For the row right-click try this line Application.CommandBars("row").Enabled = True For columns use "column" Gord On Sat, 3 Dec 2005 00:13:02 -0800, "Sean" wrote: Gord, That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#9
|
|||
|
|||
unhide menu bar in excel - just disappeared
Gord,
answers to questions below projects dosn't look anything strange, but not sure exactly what I am looking for. No add-ins active No Personal.xls No Hidden files No file in startup changes revert back to as it was as soon as I close excel any further options? Many thanks for all so far Sean... "Gord Dibben" wrote: Sean You have an add-in or your Personal.xls opening with some workbook_open or auto_open code that disables these items. Hit ALT + F11 to see what workbooks/projects are showing up in the Project Explorer. Maybe one in there with some code. Go to ToolsAdd-ins and see what you have checked in there. You may have to uncheck all the add-ins then start Excel and add them back one at a time until you find the one that is doing the deed. Currently, do you see Personal.xls in WindowUnhide? There are a couple of other options. Check out your XLSTART folder for files that may be opening hidden. C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART In ToolsOptionsGeneral do you have a path in "At startup, only all files in"? If so, delete that path. After you have a look around post back with the results. Gord On Sat, 3 Dec 2005 12:23:01 -0800, "Sean" wrote: Gord, Is there any way of keeping this so it opens correctly every time I open Excel. All this commands work but when I close Excel down all the changes revert back to as it was before with out menu bar or right hand mouse options. When I have got it back and in excel is there any options I need to choose to make it permanent. I have deinstalled office and reinstalled it today, so is this a registery setting. "Gord Dibben" wrote: Sean For the row right-click try this line Application.CommandBars("row").Enabled = True For columns use "column" Gord On Sat, 3 Dec 2005 00:13:02 -0800, "Sean" wrote: Gord, That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
#10
|
|||
|
|||
unhide menu bar in excel - just disappeared
Sean
Excel saves most configurations in the *.XLB file when you close it out. After running the lines I gave you in the Immediate Window to enable those items, Excel should save that configuration. With Excel closed............ Do a file search for *.XLB. There may be more than one. Change name(s) to *.XLBOLD or similar. Re-open Excel and what do you get? If your menu and right-clicks are still missing your problem lies with some workbook opening that disables them. Gord On Sun, 4 Dec 2005 01:53:02 -0800, "Sean" wrote: Gord, answers to questions below projects dosn't look anything strange, but not sure exactly what I am looking for. No add-ins active No Personal.xls No Hidden files No file in startup changes revert back to as it was as soon as I close excel any further options? Many thanks for all so far Sean... "Gord Dibben" wrote: Sean You have an add-in or your Personal.xls opening with some workbook_open or auto_open code that disables these items. Hit ALT + F11 to see what workbooks/projects are showing up in the Project Explorer. Maybe one in there with some code. Go to ToolsAdd-ins and see what you have checked in there. You may have to uncheck all the add-ins then start Excel and add them back one at a time until you find the one that is doing the deed. Currently, do you see Personal.xls in WindowUnhide? There are a couple of other options. Check out your XLSTART folder for files that may be opening hidden. C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART In ToolsOptionsGeneral do you have a path in "At startup, only all files in"? If so, delete that path. After you have a look around post back with the results. Gord On Sat, 3 Dec 2005 12:23:01 -0800, "Sean" wrote: Gord, Is there any way of keeping this so it opens correctly every time I open Excel. All this commands work but when I close Excel down all the changes revert back to as it was before with out menu bar or right hand mouse options. When I have got it back and in excel is there any options I need to choose to make it permanent. I have deinstalled office and reinstalled it today, so is this a registery setting. "Gord Dibben" wrote: Sean For the row right-click try this line Application.CommandBars("row").Enabled = True For columns use "column" Gord On Sat, 3 Dec 2005 00:13:02 -0800, "Sean" wrote: Gord, That's Great Thanks. My menu bar has all appeared, but the right hand mouse button functions are still not working. When you highlight a row for example you can right click and you get options to cut / paste / format ect. this is something I do a lot to speed up my work, any Ideas Sean... "Gord Dibben" wrote: Sean Hit ALT + F11 to get to the Visual Basic Editor. Do you have a menu here? If so ViewImmediate Window. Copy/paste this in there and hit ENTER. Application.CommandBars("Worksheet Menu Bar").Enabled = True Also....... Application.CommandBars("Cell").Enabled = True ALT + Q to go back to Excel Window. OK now? Gord Dibben Excel MVP On Fri, 2 Dec 2005 08:22:02 -0800, "Sean" wrote: Zack, There is no menu bar at the top of page. no option to go to file / view / tools / edit can anyone help. In excel when you right click in cell / row can't get options cut / paste/ format etc. Sean... "Zack Barresse" wrote: Hello Sean, Not sure what "right hand mouse functions" are, but try Tools | Customize | Toolbars | Worksheet Menu Bar (checked). -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Sean" wrote in message news I have been working in Excel 2003 and the menu bar and the right hand mouse functions have all disapperaed, I can't find any help to get them back |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New menu will eventually dissapear in Excel | Nash | General Discussion | 1 | November 18th, 2005 06:00 PM |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Saving Excel document blows up Infragistics menu in frame | Amy B | General Discussion | 1 | October 24th, 2004 04:57 AM |
Can't Open MDE | LouisianaLinda | General Discussion | 10 | September 18th, 2004 01:21 PM |
Right Click menu has disappeared (Excel) | Dick Kusleika | Setting up and Configuration | 0 | March 17th, 2004 10:00 PM |