View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Making User defined functions available in all new workbooks

Save them in an add-in:

http://www.cpearson.com/excel/AutomationAddIns.aspx


--
Gary''s Student - gsnu200835


"Alco Engineer" wrote:

Hi Guys,

I have a few basic user defined functions I've made up so that I can easily
calculate and also avoids common errors I've made.

Can I set up a template, or something similar, that will automatically load
the user defined functions into all future new workbooks I open?

Cheers,