When I right-click the mouse in a cell nothing happens

[Danielle]

When I right-click the mouse in a cell nothing happens.
Usually there is a menu which appears allowing me to
changes the cell's format, etc. How do I get this
function back. I can right click in other applications
and a menu appears, so I know it is a problem only with in
my excel worksheets.

PLEASE HELP!!!!!!!!!

 

[Dave Peterson]

Does it happen in every worksheet of every workbook?

If yes, then try this:
Start excel
hit alt-F11 (to get to the VBE)
hit ctrl-G (to get to the immediate window)

copy this and paste it in and hit enter:
application.commandbars("cell").enabled = true

then paste this in and hit enter:
application.commandbars("cell").reset

Then back to excel to test it.

If it didn't work, you can:
close excel
use windows start button to search for *.xlb.
rename it (them??) to *.xlbOLD

Restart excel and test it.

If it worked, then you can dump the *.xlbOLD files and rebuild your customized
toolbars at your leisure. (*.xlb is where excel stores toolbar info.)

If it only happens in one workbook, maybe the developer didn't want you to use
rightclick on the worksheets in that workbook.

Close excel
windows start button
excel /safe
(this opens excel in safe mode)

Open your workbook and test it out.

If it's ok, then talk to the person who developed it and explain what they did
to you.