View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary L Brown Gary L Brown is offline
external usenet poster
 
Posts: 219
Default invoke an event procedure with a shortcut key

I don't think you can assign a key combination to the
"Worksheet_BeforeRightClick" event because that event requires the activecell
target range. Otherwise it bombs.
If you want to simply open the Cell commandbar...
Application.CommandBars("Cell").ShowPopup
will do it.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


" wrote:

Hi all
Is there a way to invoke a worksheet event procedure using some kind of
key combination?
Specificly, I would like to assign some key combination that will
invoke the "worksheet_beforerightclick" event, whithout using the
mouse, and without changing the EditDirectlyInCell property.
Thanks in advance

BawNK