Right mouse click doesn't work

  • Thread starter Thread starter Shopper
  • Start date Start date
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!!!
 
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
 
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.
 
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...
 
Back
Top