HELP!- Mouse Right Click doesn't work in Excel workbook

M

mengxi

Please help.

when i right click my mouse in excel workbook, no menu pops up!

Please help!
 
D

Dave Peterson

Is it broken only in one workbook?
Is it broken in all the worksheets in that workbook?

If it's all worksheets in all workbooks:
Hit alt-f11 (to see the VBE--where macros live)
hit ctrl-G (to see the immediate window)

type this and hit enter:
application.commandbars("cell").enabled = true

then back to excel to test it.

If it still fails (back to the immediate window) and:
application.commandbars("cell").reset

Back to excel to test.

If it's still broken:
close excel
Use windows|find to find *.xlb (search in hidden folders for hidden files, too).

Rename it/them to *.xlbOLD.

Restart excel and try it out.

If it worked, then delete those *.xlbOLD files.
if it didn't work, then rename them to *.xlb.

*.xlb is where excel stores customized changes to the toolbar. It sounds like
yours got hosed (technical term).

If you end up deleting your *.xlb, then you'll have to do your customizations
again.
 
Top