Saving Macro In Personal Macro Workbook

  steviegee 08:46 24 Jan 2011
Locked

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.

  VoG II 08:53 24 Jan 2011

This should help click here

  steviegee 09:08 24 Jan 2011

I really can't get my head round that! Could you possibly simplify it for me VoG please. I have a spreadsheet and opened VBA and pasted in a code that you have given me before, then what...

  VoG II 09:16 24 Jan 2011

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

  steviegee 09:37 24 Jan 2011

Thanks, got there not sure how though lol.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?