Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference macro in another workbook
I want to have a worksheet that contains macro code. (macros.xls)
If I create a new workbook how do I reference macros in the above workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference macro in another workbook
You can open macros.xls and then use the macro dialog to run the subroutines.
(Hit alt-f8, select the macro to run and click the run button. If you have functions in macros.xls, you can use them in cells in your other workbook like: =macros.xls!myFunc(a1,b1) If this doesn't answer your real question, you may want to give more details. samuel wrote: I want to have a worksheet that contains macro code. (macros.xls) If I create a new workbook how do I reference macros in the above workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Reference workbook name | Excel Worksheet Functions | |||
Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |