Availability of User-Defined Function in new Excels

  • Thread starter Thread starter brett.kaplan
  • Start date Start date
B

brett.kaplan

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.
 
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.
 
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.
 

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

Similar Threads

Having a macro/function available in new spreadsheets 1
defining global function to be used in multiple cells 1
Access ConcatRelated() Function Not Working 0
no user-defined category 3
Using If Function with a Data Validation List 1
Excel TWO Instances of Excel One watching Other 3
New instance of Excel when opening different sheets 1
Conversions using User Defined Functions 1

Back
Top