Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Default User Defined Functions - How?
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 |
#2
|
|||
|
|||
Save them as *.xla (save asadd-in), then check them under toolsadd-ins
Regards, Peo sjoblom "flycast" wrote: 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 |
#3
|
|||
|
|||
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 "flycast" wrote in message ... 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
If they don't have the addin, then they'll get errors.
flycast wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions | |||
I have user defined functions in sprdsheet. I want to put sprdsh. | Excel Worksheet Functions | |||
Excel user defined functions. | Excel Worksheet Functions | |||
User defined charts- font size too small | Charts and Charting in Excel |