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;
- Apr 21 Sat 2007 20:37
I can't get a drop down list when a do a right click on a cell
close
全站熱搜
留言列表
發表留言