I need to copy macros from personal workbook to new workbook

[Bill M]

I am new to using macros.... I have created some macros; they have been saved in my personal. I would like to copy them in to a worksheet template so they will allow other users to access. What would you suggest as to the best location in the template?

Thank you for your help in advance

Bill

[hafizimran]

1. Open your template worksheet and Press Alt+F11 to open VBA editor.
2. Go to Insert-->Module in visual basic for applications editor window.
3. Expand VBAProject (Personal.xlsb) from left side (Project Explorer).
4. Open recorded macros modules (Module1, Module2,...) one by one by double clicking and copy the entire code from each module to the Template worksheets newly inserted module (Module1) created in step 2.

[LJMetzger]

Welcome Bill,

a. First, go to the Visual Basic Environment.
b. Press CTRL-R to get the 'Project Explorer.
c. Press F4 to get the 'Properties' Box.
d. Click on 'Module1' or any other Macro code module.
e. In the name box, change the name from 'Module1' to something useful like 'ModUtilities' or 'ModUtilitiesGeneral' or 'ModUtilitiesProject' or 'ModSummary'.

Each module can contain several Macros. Put the Macros into one or more 'Modules' that
make sense to you. After you've done that, you can copy them to the template by using:
a. Cut and Paste into a new module you created on the Template. You then have to rename the
Module on the Template, or
b. Right Click on the Module you want in the Template.
Left Click on 'Export File.' The Module will be saved and (will not be deleted from the source) .
Right Click on the Template in 'Project Explorer (assuming the Template file is open).
Left Click on 'Import File' and the selected file will be imported to the Template.

My personal preference is to NOT store Macros in the PERSONAL area even though they are common to all workbooks, with the exception of several one liners I use in developing software such as turning Sheet Protection On or Off.

I hope this helps.

Lewis

[JOHN H. DAVIS]

In case you are looking to do this with VBA look here.

http://www.cpearson.com/Excel/vbe.aspx