Hi,

I just created a User-Defined Function and was wondering how I can get
it to be available everytime I open a new Excel instance?

Thanks!

Brett

Put it in your XLStart folder.

Or leave it where it is and install it via tools|addins.





wrote:

Hi,

I just created a User-Defined Function and was wondering how I can get
it to be available everytime I open a new Excel instance?

Thanks!

Brett

--

Dave Peterson

After reading Kevin's response...

If you save the file as an addin, then you can use tools|addins will work ok (as
will saving the addin in XLStart).

If you want to save the file as a normal workbook, then most people would save
the file and name it personal.xls and store in that XLStart folder.

If the file is saved as an addin, you'll be able to use a formula like:

=myFunction(a1)

If you save the file as a normal workbook (personal.xls in xlstart), you'll have
to use:

=personal.xls!myfunction(a1)

===
Most people will save that personal.xls file as a hidden file.

With personal.xls the active workbook, window|hide, then close excel and answer
yes to save it. The next time you start excel, personal.xls will open in a
hidden state.


Dave Peterson wrote:

Put it in your XLStart folder.

Or leave it where it is and install it via tools|addins.

wrote:

Hi,

I just created a User-Defined Function and was wondering how I can get
it to be available everytime I open a new Excel instance?

Thanks!

Brett

--

Dave Peterson

--

Dave Peterson

In an Excel file that contains nothing but your user defined functions do
FILE/SAVE AS and change the file type to MICROSOFT OFFICE ADD-IN.

Then, in a workbook file, click TOOLS/ADD INS and click the check box to the
left of the add in you just saved.
--
Kevin Backmann


" wrote:

Hi,

I just created a User-Defined Function and was wondering how I can get
it to be available everytime I open a new Excel instance?

Thanks!

Brett