Saving Macro Shortcuts to All Workbooks

[UWHusky]

Hello,

I have a number of relatively simply macros that I have created and saved in my personal workbook. One of the macros assigns a shortcut keystroke to the other macros (see below with two of the hotkeys that are assigned listed).

Sub SetShortcutKeys()​

With Application​

​

.OnKey Key:="^+b", Procedure:="TextBlue"​

.OnKey Key:="^+r", Procedure:="TextRed"​

End With​

End Sub​

The issue is that I have to run the "SetShortcutKeys" macro each time I open Excel for these hotkeys to be set. How can I have these hotkeys saved so that I no longer need to run the macro every time I open Excel (unless of course I make changes to the hotkeys or the macros they run)?

I am using Excel 2010 and Windows 7.

Thanks!

 

[Logit]

.
In ThisWorkbook, paste the following code :

Option Explicit


Private Sub Workbook_Open()
    SetShortcutKeys
End Sub

 

[UWHusky]

.
In ThisWorkbook, paste the following code :

Option Explicit


Private Sub Workbook_Open()
    SetShortcutKeys
End Sub

Works great. Thanks!

 

[Logit]

You are welcome