Way to receive any keystrokes from COM Add-in?

S

Shahin Musayev

Hello everybody!

I'm developing a COM Add-in and it should run some routines in
response on keystrokes (like CTRL+C etc).

So I decided to use subclassing to resolve my problem. Using Spy++ I
identified that WM_KEYDOWN, WM_SYSKEYDOWN messages are sent to EXCEL7
window (workbook window). So I tried to subclass that one. But the
problem I faced is that my new window procedure receives WM_KEYDOWN,
WM_SYSKEYDOWN messages only in case key combination is not used by
Excel and not assigned to macro by OnKey method.

1) Is there any way to receive any keystrokes from COM Add-in?
2) Is there any way to override key combinations used by Excel and
defined by OnKey method?

Any help would be greatly appreciated, thanks!!!!

Shahin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to record keystrokes and mouse clicks 3
Calling Excel methods from a different thread (COM add-in) 1
Using com add-in vs digital certs for app 1
Any sample/tutorial VB6 excel COM-Add-in? 3
COM Add-In Install Location 1
Creating COM Objects or Add-Ins from VBA 1
COM Add-in file location 2
How to call COM Add-In functions from a macro 3

Top