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?

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