software

I'm using XP office 2002. All of a sudden in excel only when I right click a
cell or anything for that matter the normal drop down list that has all the
shortcuts is no longer working. I must have a setting that is off and I can't
figure it out. Now anywhere else within any other program this function works
fine with no problems, so i must be in excel. Any ideas? Please help.
thanks

Ed,

Press Alt plus F11 (Takes you to VBE)
Press Ctrl plus g (Access to Immediate Window)
Type in the following line
Commandbars(quot;Cellquot;).Reset
Press Enter and then press Alt plus Q to return to Excel

Stevequot;Edquot; gt; wrote in message
...
gt; I'm using XP office 2002. All of a sudden in excel only when I right click
gt; a
gt; cell or anything for that matter the normal drop down list that has all
gt; the
gt; shortcuts is no longer working. I must have a setting that is off and I
gt; can't
gt; figure it out. Now anywhere else within any other program this function
gt; works
gt; fine with no problems, so i must be in excel. Any ideas? Please help.
gt; thanks
Ed

Sounds like code disabled the right-click menu.

Run this macro.

Sub reset()
Application.CommandBars(quot;Cellquot;).Reset
End Sub

Or just run Application.CommandBars(quot;Cellquot;).Reset from the Immediate Window.

I would also be looking at any workbooks or add-ins that may have code running
to disable the right-click menu if it occurs again.Gord Dibben Excel MVPOn Wed, 21 Dec 2005 12:50:05 -0800, quot;Edquot; gt; wrote:

gt;I'm using XP office 2002. All of a sudden in excel only when I right click a
gt;cell or anything for that matter the normal drop down list that has all the
gt;shortcuts is no longer working. I must have a setting that is off and I can't
gt;figure it out. Now anywhere else within any other program this function works
gt;fine with no problems, so i must be in excel. Any ideas? Please help.
gt;thanks