Consolidating Recorded Macros in Personal.xlsb into one Module.

[RunTime91]

Greetings All - Happy Friday!

Got a pesky one here - (at least for me it's pesky)

I have many recorded macros in my Personal.xlsb Workbook using (at least for now) keyboard shortcuts to trigger them

When I record these macros the Personalxlsb creates a new module to put it in; which is fine until I try to copy/paste the macro into just the first module in an attempt to consolidate.

Once copied the macro still works fine on step-through, but the keyboard shortcut doesn't???

Is there a way/technique to consolidate my macros so they are all in one place and all the keyboard shortcuts still work as well??

Thanks

 

[My Aswer Is This]

Copy all your Macros into the same Module:
Then put just that one Module in your Personal folder

Your combined module would look something like this:

Sub Hello()
MsgBox "Hello"
End Sub
Sub Goodbye()
MsgBox "Goodbye"
End Sub
Sub Go_Home()
MsgBox "Go Home"
End Sub