About Us

Alco Engineer[_2_]

Thanks guys,

That sorts it nicely.

"Shane Devenshire" wrote:

Hi,

Here is what you can do easily in Excel - you can create a basic Excel
add-in and then attach it. Its functions will be available whenever it is
attached. So if you want to distribute your files that are using the add-in
you need to provide the user with a copy of the add-in and attach it on their
machines.

1. Put all your function in a single workbook.
2. (Optional) in Excel choose Window, Hide.
3. Choose File, Save As, and under the Files of Type choose Microsoft
Office Excel Add-In (*.xla) near or at the bottom of the list.
4. Note the add-ins location or change the location to anywhere you want
and click Save.
5. Exit Excel and restart it (this is quicker that the alternative)
6. Choose Tools, Add-Ins, and click Browse and navigate to the location
where you saved your xla. Choose it and click OK.
7. In the Add-ins dialog box make sure your add-in is checked and click OK.

You functions will be available to all of your spreadsheets opened on this
computer.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Alco Engineer" wrote:

You'll have to excuse my ignorance.

I've tried following the instructions that you linked to, however I can't
open VB on it's own, I only open up excel and then view code and make my
changes that way.

Is there a way to do this using the excel VB? I can't seem to save anything
as a DLL file which means I can't seem to get it to save as an add-in.

Cheers,

"Gary''s Student" wrote:

Save them in an add-in:

http://www.cpearson.com/excel/AutomationAddIns.aspx

--
Gary''s Student - gsnu200835

"Alco Engineer" wrote:

Hi Guys,

I have a few basic user defined functions I've made up so that I can easily
calculate and also avoids common errors I've made.

Can I set up a template, or something similar, that will automatically load
the user defined functions into all future new workbooks I open?

Cheers,

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Defined Functions	CH	Excel Worksheet Functions	4	September 22nd 08 10:16 AM
User defined functions without using VBA.	[email protected]	Excel Worksheet Functions	0	June 13th 06 05:49 PM
User Defined Functions	Mike McLellan	Excel Worksheet Functions	2	May 4th 06 10:56 AM
About User Defined Functions	linzhang426	Excel Worksheet Functions	4	October 17th 05 09:27 PM
User Defined Functions	Jeff B	Excel Worksheet Functions	1	April 27th 05 09:59 PM

Menu

About Us