View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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