You can reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate 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.

ToolsProtectionUnProtect Worksheet.


Gord

On Tue, 19 Sep 2006 17:53:02 -0700, j wrote:

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" wrote:

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

On Tue, 19 Sep 2006 06:21:01 -0700, j wrote:

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