Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 05, 06:46 PM posted to microsoft.public.excel.setup
Sean
 
Posts: n/a
Default 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   Report Post  
Old December 1st 05, 02:03 AM posted to microsoft.public.excel.setup
Zack Barresse
 
Posts: n/a
Default 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   Report Post  
Old December 2nd 05, 05:22 PM posted to microsoft.public.excel.setup
Sean
 
Posts: n/a
Default 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   Report Post  
Old December 2nd 05, 09:04 PM posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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   Report Post  
Old December 3rd 05, 09:13 AM posted to microsoft.public.excel.setup
Sean
 
Posts: n/a
Default 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   Report Post  
Old December 3rd 05, 06:01 PM posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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   Report Post  
Old December 3rd 05, 09:23 PM posted to microsoft.public.excel.setup
Sean
 
Posts: n/a
Default 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   Report Post  
Old December 3rd 05, 10:27 PM posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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   Report Post  
Old December 4th 05, 10:53 AM posted to microsoft.public.excel.setup
Sean
 
Posts: n/a
Default 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   Report Post  
Old December 4th 05, 06:45 PM posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
'Save As' menu disabled in Excel Govind Excel Worksheet Functions 1 October 21st 05 04:14 AM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 09:49 PM
When I select "Open" from the "File" menu in Excel, I get only a . dan Excel Discussion (Misc queries) 1 December 1st 04 12:25 AM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 09:39 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017