cannot right-click a shortcut menu in Excel
 

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?

cannot right-click a shortcut menu in Excel
 

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?

cannot right-click a shortcut menu in Excel
 

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?

cannot right-click a shortcut menu in Excel
 

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

cannot right-click a shortcut menu in Excel
 

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

cannot right-click a shortcut menu in Excel
 

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?

cannot right-click a shortcut menu in Excel
 

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

cannot right-click a shortcut menu in Excel
 

jumpling has never caused me any harm but like anything else, should be used
only in moderation.



On Sun, 08 Apr 2007 12:38:34 -0500, Dave Peterson
wrote:

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?

cannot right-click a shortcut menu in Excel
 

After using excel again, I realized that the previous macro did turn on the
menus for cells but did not turn back on the short cut menus for rows,
columns and charts. With a little digging I came up with the following macro
that appears to have enabled all the right-click shortcut menus.

Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub

Thanks Gord and Dave for setting me in the right direction.



"Gord Dibben" wrote:

jumpling has never caused me any harm but like anything else, should be used
only in moderation.



On Sun, 08 Apr 2007 12:38:34 -0500, Dave Peterson
wrote:

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?

cannot right-click a shortcut menu in Excel
 

Thanks for the feedback John.

Good job of digging.


Gord

On Tue, 10 Apr 2007 09:28:00 -0700, John wrote:

After using excel again, I realized that the previous macro did turn on the
menus for cells but did not turn back on the short cut menus for rows,
columns and charts. With a little digging I came up with the following macro
that appears to have enabled all the right-click shortcut menus.

Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub

Thanks Gord and Dave for setting me in the right direction.



"Gord Dibben" wrote:

jumpling has never caused me any harm but like anything else, should be used
only in moderation.



On Sun, 08 Apr 2007 12:38:34 -0500, Dave Peterson
wrote:

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?

Regarding Right click in Excel
 

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