I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

"Gord Dibben" wrote:

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?

Try one mo

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

John wrote:

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

"Gord Dibben" wrote:

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?



--

Dave Peterson

Thank you Dave Peterson. That corrected the problem. You made my Saturday!!

Thanks again,

"Dave Peterson" wrote:

Try one mo

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

John wrote:

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

"Gord Dibben" wrote:

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?



--

Dave Peterson

Thanks for jumpling in Dave.


Gord

On Sat, 07 Apr 2007 18:40:18 -0500, Dave Peterson
wrote:

Try one mo

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

John wrote:

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

"Gord Dibben" wrote:

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?

You're welcome, Gord.

(I just hope that "jumpling" is a good thing <vbg.)

Gord Dibben wrote:

Thanks for jumpling in Dave.

Gord

On Sat, 07 Apr 2007 18:40:18 -0500, Dave Peterson
wrote:

Try one mo

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

John wrote:

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

"Gord Dibben" wrote:

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?



--

Dave Peterson

Go to Task Manager and search for Verclsid and end task.
Then go to C:\Windows and search for the same file and rename it (Verclsidold).
Re-open Excel and it should work.
If that does not work perform the below steps :-
*Excel11.xlb [D:\Documents and Settings\username\Application Data\Microsoft\Excel], remove the file and save it in a different location
{Eg:-desktop}.
* Reopen excel and excel11.xlb gets created.[Delete the previous excel11.xlb once you confirm from user its all working fine]

*unregister and register excel
[Unregister - Start- run - excel /unregsvr, Register - excel /regsvr]



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com