transfer a macro to the personal macro worksheet
 

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

transfer a macro to the personal macro worksheet
 

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 ToolsMacrosRecord 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 (WindowsUnhide)

--
__________________________________
HTH

Bob

"DianeG" wrote in message
...
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

transfer a macro to the personal macro worksheet
 

thanks very much I'll give it a go

"Bob Phillips" wrote:

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 ToolsMacrosRecord 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 (WindowsUnhide)

--
__________________________________
HTH

Bob

"DianeG" wrote in message
...
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