Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can override almost any Excel shortcut Key by using
Application.OnKey key, Macroname For example, this uses the [CTRL+SHIFT+ 9 aka left/open parens "("] and overrides the built-in command to Unhides any hidden rows within the selection. Application.OnKey "+^9", "MyMacro" Now [CTRL+SHIFT+ (] runs MyMacro. HOWEVER, no matter what I've tried, I cannot override [CTRL+SHIFT+ 0] aka [CTRL+SHIFT+ )] I tried to tell Excel to do nothing with the shortcuy key by using a blank string Application.OnKey "+^0", "" or Application.OnKey "+^{)}", "" note: you have to use {} to esacpe the ")" then set the shortcut key to be custom and run MyMacro. Application.OnKey "+^0", "MyMacro" or Application.OnKey "+^{)}", "MyMacro" pressing [CTRL+SHIFT+ )] will cotinue to run the built-in command Unhides any hidden rows within the selection. Is there special something about [CTRL+SHIFT+ )] aka [CTRL+SHIFT+ 0] in Excel 2007? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Shortcut Keys (Y01 - Y18) | Excel Discussion (Misc queries) | |||
Excel 2007 shortcut keys | Excel Discussion (Misc queries) | |||
Reassign built-in shortcut keys in excel 2007 | Excel Discussion (Misc queries) | |||
Shortcut keys in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 ribbon shortcut keys | Excel Discussion (Misc queries) |