| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference active worksheet from macro in personal.xls | Excel Programming | |||
| Macro needed to transfer numerical values in cell from one worksheet to another | Excel Programming | |||
| I need a macro to grab specific data and transfer it to a now worksheet | Excel Programming | |||
| Assigning a macro to a worksheet (vs personal.xls) | Excel Programming | |||
Hybrid Mode
