How to establish current ONKEY status?

  • Thread starter Thread starter John Mitchell
  • Start date Start date
J

John Mitchell

Gurus...

Is there a way of querying the current ONKEY procedure associated with a
particular key? On activating a workbook I'd like to set a menu hotkey, and
on deactivating the workbook I'd like to restore the previous setting. The
help for ONKEY only covers setting, not querying, so the best I have been
able to do is restore the key to its Excel default state which is not
necessarily the same as the key state at the time the workbook was
activated.

Regards, John Mitchell
 
I don't know of a way to query onkey. I think it's write-only.

--
Jim Rech
Excel MVP
| Gurus...
|
| Is there a way of querying the current ONKEY procedure associated with a
| particular key? On activating a workbook I'd like to set a menu hotkey,
and
| on deactivating the workbook I'd like to restore the previous setting. The
| help for ONKEY only covers setting, not querying, so the best I have been
| able to do is restore the key to its Excel default state which is not
| necessarily the same as the key state at the time the workbook was
| activated.
|
| Regards, John Mitchell
|
|
 
You must log in or register to reply here.

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

Disable Cut/Copy/Paste in Excel 2010 0
Run macro when file is opened and closed 2
assign onkey to 1 worksheet 5
Assign different keyboard shortcuts 4
OnKey 2
OnKey - usable to assign new shortcuts to existing Excel keyboardshortcuts? 2
Way to receive any keystrokes from COM Add-in? 2
How to get Last Key or Key-Combo Pressed (Not Event)? 0

Back
Top