View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Brown Andy Brown is offline
external usenet poster
 
Posts: 36
Default BeforeRightClick - XL2K on XP_Home

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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.


I'm OK there ; I already have a few. It's just the user does a lot of
keyboarding, so rather than keep switching to the mouse I was hoping for
OnKey {CELL-commandbar-key} if column = 3, sub1 ; if column = 5, sub2, etc.

Thanks for your comments.

Rgds,
Andy