Default User Defined Functions - How?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some user defined functions that I use quite often. I want to have all
my user defined functions accessable by any workbook that I start at any
time. I do not want to have to open a module that contains the functions and
copy and paste then inside the new workbook.

How con I make all my user defined functions show up in the user defined
function section by default?

Thanks,
Eric
 
Save them as *.xla (save as>add-in), then check them under tools>add-ins

Regards,

Peo sjoblom
 
Store them in your personal.xls workbook, typically located in
C:\Program Files\Microsoft Office\Office\XLStart and make this
workbook hidden.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks for the reply...both of you.

Follow up question...
I I use one method or the other. Say I create a workbook that uses some of
the formulas and then send that workbook to a coworker, will my formulas go
with it or will it end up displaying a #name error?

Thanks,
Eric
 
Back
Top