View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean@ERYC[_2_] Dean@ERYC[_2_] is offline
external usenet poster
 
Posts: 10
Default defign a function in one workbook and use it in another workbook

I am trying to open a workbook eg book2.xls from vba code in book1.xls and
want to then use a user defigned function defigned in book1.xls in book2.xls.

I can open book2.xls ok and can insert columns and paste 'normal' excel
functions into the cells but want to paste a user defigned function in and
cannot work out how to do it.

Any help greatly aprechiated.

Dean.