How do I get the right click function back(on my mouse)?

M

Michelle

I try to right click on my mouse when I need to edit a cell but nothing
happened. Can anyone tells me how to get that function back. I have been
use this function forever but just lost it two days ago.
 
G

Gord Dibben

Right-click on a cell should bring a menu, not put you into Edit Mode.

What do you mean by "Edit a cell"?

Where are you right-clicking?

Did you mean to say "double-click" on a cell does not put you into Edit
Mode?

Maybe you unchecked "Edit directly in cell" in Excel Options?


Gord Dibben MS Excel MVP
 
G

Gord Dibben

In case you did mean no cell right-click menu at all......

Perhaps some code you ran disabled it.

Alt + F11 to open VBE.

View>Immediate Window.

Copy this into that window and hit ENTER key.

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

Alt + q to return to Excel............OK now?


Gord
 
M

Michelle

Gord,

Yes, What I mean is when I right-click the mouse now Edit drop down menu at
all right now.......

You are right, I have a add-in done last week is called "Essbase". Then I
lost my Edit drop sown menu when I click the cell.

I have followed your instruction by still didn't get this function back.
Can you please help?

Thanks,
Michelle
 
M

Michelle

Hi Gord,

I get the right-click Edir drop down menu fuction back by disable the add-in
"double click" function.

Thanks!
 
G

Gord Dibben

Good to hear.

I do not like those applications that change the Excel operation in that
manner.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top