How do I activate right mouse button in Excel

[Gerhard]

The dropdown on the right mouse button suddenly disappeared. It works with
all other programs except Excel. I opened an Excel file that contains major
Visual Basic Programming. When I closed it, the scroll bars were missing and
it EXcel was set to full screen view. I managed to get all of it back by
cahnging it in Options, but now I don't have a dropdown on the right mouse
button.

 

[Gord Dibben]

Sounds like code disabled the Cell right-click menu and other stuff<g>

Run this macro.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

How about if you right-click on a sheet tab?

If sheet tab r-click is also disabled you need

Sub reset()
Application.CommandBars("Plyl").Enabled = True
End Sub


Gord Dibben MS Excel MVP

 

[JP]

<gasp> What kind of code removes the scrollbars and rghtclick menu
then doesn't clean itself up after exiting??

--JP

 

[Gord Dibben]

Rhetorical question, I presume<g>


Gord

<gasp> What kind of code removes the scrollbars and rghtclick menu
then doesn't clean itself up after exiting??

--JP

 

[JP]

Absolutely!


--JP

Rhetorical question, I presume<g>

Gord