close

When I am in Excel and do a right mouse click I do not see the drop down list
that shows the available commands (i.e. cut, copy, etc.).

Perhaps your right-click has been altered by a macro you ran.

Hit ALT F11 to go to the VBEditor.

Then Viewgt;Immediate Window.

Copy/paste this line into the window and hit lt;entergt;

Application.CommandBars(quot;Cellquot;).Enabled = True

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

Sub reset()
Application.CommandBars(quot;Cellquot;).Enabled = True
End Sub

Do you now have a right-click menu?

If so, I would start looking for what disabled it in the first place.Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 08:39:08 -0800, csanchez gt;
wrote:

gt;When I am in Excel and do a right mouse click I do not see the drop down list
gt;that shows the available commands (i.e. cut, copy, etc.).

Gord Dibben MS Excel MVP

That fixed the problem. It must have been altered by a macro because it
started happening after running a macro. Thanks!

quot;Gord Dibbenquot; wrote:

gt; Perhaps your right-click has been altered by a macro you ran.
gt;
gt; Hit ALT F11 to go to the VBEditor.
gt;
gt; Then Viewgt;Immediate Window.
gt;
gt; Copy/paste this line into the window and hit lt;entergt;
gt;
gt; Application.CommandBars(quot;Cellquot;).Enabled = True
gt;
gt; OR copy/paste this sub to a module and run it.
gt;
gt; Sub reset()
gt; Application.CommandBars(quot;Cellquot;).Enabled = True
gt; End Sub
gt;
gt; Do you now have a right-click menu?
gt;
gt; If so, I would start looking for what disabled it in the first place.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 9 Mar 2006 08:39:08 -0800, csanchez gt;
gt; wrote:
gt;
gt; gt;When I am in Excel and do a right mouse click I do not see the drop down list
gt; gt;that shows the available commands (i.e. cut, copy, etc.).
gt;
gt; Gord Dibben MS Excel MVP
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()