Saving VBA

G

Guy Wates

How do I save User defined function that I create with VBA so that the
are available in every new workbook that I ope
 
C

Chip Pearson

Guy,

Save the workbook containing the functions as an Add-In. Then, go to the
Tools menu, choose Add-Ins, and load your add-in. You can then call the
function directly from a worksheet cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top