Assigning Shortcuts to Macros using "Alt"

[zkest]

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!

 

[mkw4949]

I dont know if this will work for you but what I did when my keyboard could no long accomodatemy macros is I added an item to the Tool Bar labled "Macros" and added a shortcut key to it. "Alt+m" in my case. Once I did that I added all the macros to the new tool bar and set up hot keys for them. Good luck.

 

[zkest]

Thanks, Mike. That's definitely a possible work-around. The only issue with that approach is if I want to run the same macro twice in a row (if, say, the macro multiplied the current cell by 10, and I wanted to multiply it by 100). In that case, I would have have to press "alt-m-f", then "alt-m-f" again, whereas my ideal solution would be to hold down "alt-shift", and just press "f" twice. I know I'm being very picky (but then again, if i wanted to run the macro 10 times in a row, that could be a serious difference in efficiency), and I'll probably end up using your solution if I can't get exactly what I want.

Thanks again.