Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning a Shortcut Key to a Sub Procedure | Excel Discussion (Misc queries) | |||
Shortcut Key to follow a Call'ed Procedure | Excel Programming | |||
Event Procedure | Excel Programming | |||
Event Procedure again | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |