Thread
:
invoke an event procedure with a shortcut key
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary L Brown
external usenet poster
Posts: 219
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
Reply With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown