| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to reuse macros
I written a macros in an excel . How I can reuse thsese macros in another
excel without copoying the above macros or without opening the previous excel which contains macros |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to reuse macros
Store macros that you want to use in other workbooks in the PERSONAL.XLS
worksbook. This workbook opens in the background each time you open Excel and is hidden from view, but you have access to all macros in the PERSONAL workbook file. -- Kevin Backmann "pol" wrote: I written a macros in an excel . How I can reuse thsese macros in another excel without copoying the above macros or without opening the previous excel which contains macros |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to reuse macros
You probably want an addin...
http://www.cpearson.com/excel/CreateAddIn.aspx -- HTH... Jim Thomlinson "pol" wrote: I written a macros in an excel . How I can reuse thsese macros in another excel without copoying the above macros or without opening the previous excel which contains macros |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to reuse macros in an excel
Thanks for the reply
In which folder I can see that personal.xls. I am using 2007 excel. I searched entire folder also hidden but I cant see that file anywhere "Kevin B" wrote: Store macros that you want to use in other workbooks in the PERSONAL.XLS worksbook. This workbook opens in the background each time you open Excel and is hidden from view, but you have access to all macros in the PERSONAL workbook file. -- Kevin Backmann "pol" wrote: I written a macros in an excel . How I can reuse thsese macros in another excel without copoying the above macros or without opening the previous excel which contains macros |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to reuse macros
In which folder I can see that personal.xls. I am using 2007 excel. I
searched entire folder also hidden but I cant see that file anywhere "Jim Thomlinson" wrote: You probably want an addin... http://www.cpearson.com/excel/CreateAddIn.aspx -- HTH... Jim Thomlinson "pol" wrote: I written a macros in an excel . How I can reuse thsese macros in another excel without copoying the above macros or without opening the previous excel which contains macros |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to reuse macros
If you haven't recorded a macro into Personal Macro Workbook you won't have
a Personal.xls created. At least this holds for Excel 2003 and earlier. Don't know about 2007 Gord Dibben MS Excel MVP On Fri, 17 Oct 2008 09:33:07 -0700, pol wrote: In which folder I can see that personal.xls. I am using 2007 excel. I searched entire folder also hidden but I cant see that file anywhere "Jim Thomlinson" wrote: You probably want an addin... http://www.cpearson.com/excel/CreateAddIn.aspx -- HTH... Jim Thomlinson "pol" wrote: I written a macros in an excel . How I can reuse thsese macros in another excel without copoying the above macros or without opening the previous excel which contains macros |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reuse of Pivot tables | Excel Discussion (Misc queries) | |||
| how can i save my macro if i want to reuse | Excel Worksheet Functions | |||
| Want to reuse a logo in a header but can't seem to copy it | Excel Discussion (Misc queries) | |||
| can i store percentage formulas to reuse them? | Excel Worksheet Functions | |||
| How can I reuse the same Name on more than one worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
