invoke an event procedure with a shortcut key
 

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

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