Hi Everyone,
I am writing some macros for myself, and I would like to create keyboard shortcuts for them. I have third-party add-ins installed that are already using the "control-alt" and "control-shift" combinations, so I wanted to use "alt-shift" (as in "alt-shift-f" - I don't want to use "control-alt-shift" because that's just too cumbersome).
I know how to use the Application.OnKey method to set up shortcuts. If I do the following:
Application.OnKey "%+z", "MacroName"
It works fine - when I press "alt-shift-z", the macro runs. The problem arises when I write:
Application.OnKey "%+f", "MacroName"
When I type "alt-shift-f", the File menu opens! It looks like Excel is ignoring the "shift" and it thinks I want to open the file menu. My macro doesn't get called at all. Can anyone think of a solution? (I do NOT want to disable the menus for this)
Thanks!
I am writing some macros for myself, and I would like to create keyboard shortcuts for them. I have third-party add-ins installed that are already using the "control-alt" and "control-shift" combinations, so I wanted to use "alt-shift" (as in "alt-shift-f" - I don't want to use "control-alt-shift" because that's just too cumbersome).
I know how to use the Application.OnKey method to set up shortcuts. If I do the following:
Application.OnKey "%+z", "MacroName"
It works fine - when I press "alt-shift-z", the macro runs. The problem arises when I write:
Application.OnKey "%+f", "MacroName"
When I type "alt-shift-f", the File menu opens! It looks like Excel is ignoring the "shift" and it thinks I want to open the file menu. My macro doesn't get called at all. Can anyone think of a solution? (I do NOT want to disable the menus for this)
Thanks!