Defining a Shortcut Key to an Existing Macor in "Personal.xlsb"

[JeepChick]

Hi Everyone,

It's been awhile since I've posted here but I always get the answer I'm needing so I hope someone can help me with this one.

I'm trying to assing as shortcut key to an already-existing macro in my Personal.xlsb workbook. I would like to execute this macro in other workbooks using the shortcut key.

My macro is called "PIVOT_TABLE" and I'd like to assign <ctl> + <shift> + <T> to my macro. I found code that's supposed to do that, but it's not working. The code is shown below:

Application.MacroOptions Macro:=”PIVOT_TABLE”, HasShortcutKey:=True, ShortcutKey:=”T”

Does this look right to you? If so, why is it not working for me? The macro "PIVOT_TABLE" is working fine if I run it directly from Personal.xlsb.

All help is greatly appreciated...thanks!

 

[lrobbo314]

Hit Alt + F8, select the macro you want to associate your keyboard shortcut with, click Options, then enter the key you want to have a shortcut for.

 

[JeepChick]

Hit Alt + F8, select the macro you want to associate your keyboard shortcut with, click Options, then enter the key you want to have a shortcut for.

Hi, thanks for your response. I know how to do what you describe, but I need to do it through code. I have a very large audience that will be doing this and I don't want to have to instruct each of them to do the above. Want to do it through code. Any other ideas?

 

[JeepChick]

Okay, I resolved my own issue with some research. The following worked:

Application.OnKey Key:="%^t", Procedure:="C:\Program Files\Microsoft Office2007\Office12\XLSTART\Personal.xlsb!FTP_PIVOT"