View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default BeforeRightClick - XL2K on XP_Home

Andy,

AFAIK, there is no event associated with showing the CELL commandbar.

You could easily re-write your event as a standard macro and assign it a
shortcut key.... post your code if you need help.

HTH,
Bernie
MS Excel MVP

"Andy Brown" wrote in message
...
Hi all. I have a sheet with many columns and a whole BeforeRightClick

thing,
such that if rightclicked column = x, do this ; if y, do that ; if z, do

the
other. Come to think of it, I could probably use a Select Case but I
digress.

Anyway, is there any way I can get the event(s) to fire on pressing the
pop-up menu key (the one next to the r-hand CTRL)? OnKey won't cut it,
according to Help. BTW, where the heck's the CLEAR key?

TIA, either way have a good Xmas,
Andy