Refresh Event

Add-in Express™ Support Service
That's what is more important than anything else

Refresh Event
custom code on F9 
nitin c




Posts: 79
Joined: 2007-05-18
Hi,

I want to execute some code whenever user hits F9. Is there any event to trap this?

Thanks,
Nitin
Posted 22 May, 2007 10:40:27 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Nitin, please use the ADXKeyboardShortcut component to process your own shortcuts in the host application.


P.S. Note that we take up your forum requests in the order we receive them. Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
Posted 22 May, 2007 11:43:05 Top
nitin c




Posts: 79
Joined: 2007-05-18
Hi Sergey,

ADXKeyboardShortcut component's Shortcut text does not contain F9, it has Shift+F9, Ctrl+Shift+F9. I am using XP and Excel 2003.

Thanks,
Nitin
Posted 23 May, 2007 02:04:27 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Nitin, just type in F9 in the ShortcutText property and rebuild the project.
Posted 23 May, 2007 09:18:35 Top
nitin c




Posts: 79
Joined: 2007-05-18
Thanks Sergey, is there any way to cancel this event. Once I have handled it, I dont want excel to continue with it.
Posted 24 May, 2007 00:41:30 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Just set the Enabled property of the ADXKeyboardShortcut component to false.
Posted 24 May, 2007 08:22:04 Top