I can't get a drop down list when a do a right click on a cell

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 View>Immediate Window.

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

Application.CommandBars("Cell").Enabled = True

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

Sub reset()
Application.CommandBars("Cell").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 <[email protected]>
wrote:

>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.).

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!

"Gord Dibben" wrote:

> Perhaps your right-click has been altered by a macro you ran.
>
> Hit ALT + F11 to go to the VBEditor.
>
> Then View>Immediate Window.
>
> Copy/paste this line into the window and hit <enter>
>
> Application.CommandBars("Cell").Enabled = True
>
> OR copy/paste this sub to a module and run it.
>
> Sub reset()
> Application.CommandBars("Cell").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 <[email protected]>
> wrote:
>
> >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.).
>
> Gord Dibben MS Excel MVP
>