Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving UDFs in a Template?

Status
Not open for further replies.

andielangley

Programmer
Feb 11, 2003
17
GB
Hi, there may be an obvious answer to this question, but is there an Excel equivalent of the Word Normal.dot template where I can save my increasing library of VBA UDFs so they are available to every new worksheet I open? Currently I have a template called UDFLibrary.xlt which contains them, but I frequently forget to create my new spreadsheets from this template and then have to go through the hassle of copying them across. It would be so much simpler to save them into the default template!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top