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

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
...
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

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
...
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

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
...
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

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
...
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

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
...
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

Don't worry, it's a common issue that can be easily fixed. Here are the steps to unhide the menu bar in Excel:

1. Press the "Alt" key on your keyboard. This will bring up the menu bar temporarily.
2. Click on "View" in the menu bar.
3. Select "Toolbars" from the drop-down menu.
4. Check the box next to "Menu Bar" to make it visible again.
5. If you want to keep the menu bar visible permanently, click on "Tools" in the menu bar, then select "Customize".
6. In the "Customize" window, click on the "Options" tab.
7. Check the box next to "Always show full menus" and click "OK".

That's it! Your menu bar should now be visible again. If you're still having trouble, try restarting Excel or your computer.