transfer a macro to the personal macro worksheet

[DianeG]

I have a macro in a worksheet that I wish to make available to all workbooks
so I'd like to put it in the personal macro worksheet. How do i do this? I
admit up front I don't know anything about VBA so please reply in idiot speak
please!!

Thanks

diane

 

[Bob Phillips]

Personal.xls.

Personal.xls is located in the XLStart directory, and is used to store
macros and things that you want to be available to all workbooks, whenever
you start Excel.


By default, it is hidden in Excel, but if you go to the VBE, you use it as
you can with any other open workbook (you don't have to unhide it).


You can create it by
- goto Tools>Macros>Record New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up


You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (Windows>Unhide)

 

[DianeG]

thanks very much I'll give it a go

Personal.xls.

Personal.xls is located in the XLStart directory, and is used to store
macros and things that you want to be available to all workbooks, whenever
you start Excel.


By default, it is hidden in Excel, but if you go to the VBE, you use it as
you can with any other open workbook (you don't have to unhide it).


You can create it by
- goto Tools>Macros>Record New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up


You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (Windows>Unhide)

--
__________________________________
HTH

Bob