Using functions

C

C Tate

How can I use these user defined functions so that they are available
whenever I open a new workbook?
 
O

Otto Moehrbach

You need to put them in your Personal.xls file. The Personal.xls file
resides in your XLStart folder and is opened whenever Excel opens. You may
or may not have such a file.
To find out if you already have one, open Excel. Then click on Window -
Unhide. If Personal.xls is listed to unhide then you have such a file. If
it is not listed or if the "Unhide" word is grayed-out, then you don't have
one.
To create it, do this:
With Excel open, click on Tools - Macro - Record New Macro. In the
"Store macro in:" line, select Personal.xls. Click on OK. Close the macro
recorder. You now have a Personal.xls file. HTH Otto
 
D

Dave Peterson

On top of what Otto wrote:

Say you have a function in your personal.xls file called "myfunc". If you want
to use it in another workbook, you can write your formula like:

=personal.xls!myfunc(a1,a3,a5)
(pass the right arguments, though).

I've saved my personal.xl* file as an addin. The macros in it are not visible
under Tools|Macro|macros..., but I've customized my toolbar to have access to
them.

But when I want to refer to a UDF in my personal.xla, all I have to do is:
=myfunc(a1,a3,a5)
It looks like it's built into excel--or like the analysis toolpak functions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top