How I do I save a macro in my Personal Macro Workbook so that I can assign it a shortcut key so it is available in any workbook I open. I know how to do it if I am recording a macro but not if I have copied and pasted the macro in the module using alt+f11. Thanks.
I don't know how to make that any simpler. This is the bit you need:
Example 1: Macro
Public Sub Test() MsgBox "Insert your favorite code here" End Sub
1) Select the PERSONAL.XLS in the project window and click on the + before it 2) Then click on the + before Modules 3) Double click on Module1 to open the code window on the right 4) We copy/paste the example macro in this module. 5) Now use Ctrl-s or File>Save in the VBA editor to save the PERSONAL.XLS. 6) We use Alt–q to go back to Excel or use "File >Close and Return to Microsoft Excel". 7) You can run the macro then with Alt-F8 or Tools>Macro…Macros / Developer tab>Macros