Moving Macro

[windme]

Hello All, Using Excel 2007

I made up a macro that took a while to make up and saved it in the "This Workbook". How can I copy or move the macro to the personal workbook (PERSONAL.XLS) so that I can use it for any excel file.
Thanks.

Mike

[windme]

Hello All, Using Excel 2007

I made up a macro that took a while to make up and saved it in the "This Workbook". How can I copy or move the macro to the personal workbook (PERSONAL.XLS) so that I can use it for any excel file.
Thanks.

Mike

[shg]

If it's in a separate module, just drag the module in the Project Explorer window to the Personal.xls project. Or cut and paste the code into one of the existing Personal.xls modules.

[windme]

Thanks shg,
I copied and paste it into a new modle under PERSONAL.XLS.

Mike

[royUK]

You can always right click the Module & choose the Import/Export features. This way you can keep a backup uf your code in a .bas file.