Consolidating Recorded Macros in Personal.xlsb into one Module.

RunTime91

Active Member
Joined
Aug 30, 2012
Messages
256
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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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:

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

Watch MrExcel Video

Forum statistics

Threads
1,095,680
Messages
5,445,929
Members
405,370
Latest member
Miguel_Rojas

This Week's Hot Topics

Top