Right mouse click doesn't work

S

Shopper

I have the strangest problem... somehow, right clicking a cell doesn't
bring up a menu anymore. It happens only when I'm in Excel only... it still
works even if I bring up macro editor within Excel... it only doesn't work
when I'm in Excel. I've tried Options and Customize... nothing there seems
to work...
HELP!!!
 
J

JulieD

Hi

is it in every excel workbook or only one ... as code can be written against
the Worksheet_BeforeRightClick event ... but unless this code has somehow
gotten into your default template (book.xlt) i can't see how it would affect
all sheets and workbooks.

maybe something worth investigating - to see if it is the culprit, open a
workbook, press ALT & F11 to get into the VBE window, in the project
explorer (LHS of screen - or choose view / project explorer) double click on
where it says SHEET1 under your workbook and see if there's any code in
there for the Worksheet_BeforeRightClick event

Cheers
JulieD
 
D

Dave Peterson

Try this:
Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window

Type this and hit enter:
application.CommandBars("Cell").Reset
then the same with this line:
application.CommandBars("cell").Enabled = True

Hit alt-f11 to get back to excel and test it out.
 
S

Shopper

GREAT!!! It worked. Thanks a lot!


Dave Peterson said:
Try this:
Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window

Type this and hit enter:
application.CommandBars("Cell").Reset
then the same with this line:
application.CommandBars("cell").Enabled = True

Hit alt-f11 to get back to excel and test it out.
Click to expand...
 
Top