G Guy Wates Nov 20, 2003 #1 How do I save User defined function that I create with VBA so that the are available in every new workbook that I ope
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 Nov 20, 2003 #2 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
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
P Peo Sjoblom Nov 20, 2003 #3 Save it in a new workbook as xla (add-in) then select under tools>add-ins...
