i cannot use the mouse right click in excel. how to rectify?

[Guest]

i cannot use the mouse right click in excel. how to rectify?

 

[SteveW]

Is this just when over the cells ?

Does it work on the title bar - windows options
Or on the Excel menus ?

Steve

 

[Gord Dibben]

Unless the right-click button is frozen, I'm sure you can use the mouse
right-click in Excel

Just hit the right-click button.

Now...........................the real issue

What are you right-clicking on and what doesn't happen for you?

Does the right-click not work at all or just under certain circumstances?

Maybe the right-click cell menu doesn't pop-up?

If you right-click on a Toolbar what happens?

More detail please.


Gord Dibben MS Excel MVP

 

[Guest]

Hi,

when i right click the menu does not appear... other office program like
powerpoint and word ok.

also the insert and format function tool in excel greyed out?

 

[Gord Dibben]

You can reset the right-click menu.

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

The Insert and Format not being available could be because the worksheet or
workbook is protected.....I would vote for worksheet.

Tools>Protection>UnProtect Worksheet.


Gord

 

[Guest]

Thanks Gord Dibben,

will try the one on right click menu later at home...

as for protection of worksheet...unfortunately the option of "protection" is
greyed out too. main tool like insert and format also greyed out on a new
spreadsheet.

any advice on this? Thanks.

 

[Guest]

How do i make the right click menu a permanant feature?

and to make insert, format data options availabke

i am unable to unprotect worksheet as protection option greyed out...