Making VBA function available to any workbook

[krabople]

Hi, I have just written a basic function which scans a selected range of cells to see how many times a particular string appears. Is there any way that I can make this function available to all instances of Excel on my computer, as opposed to the one workbook it's written in? (ie. without having to copy the function code into every workbook)

[SOS]

Hi krabople,

If you save the function to a module in Personal.xls then it is available to every instance of Excel

[krabople]

Hi Seamus, thanks very much for the help - whereabouts will I find Personal.xls? (I've tried searching my C drive for it but couldn't find it)

[NBVC]

See here:

http://www.rondebruin.nl/personal.htm

P.S. Please read our forum rules... your title was not satisfactory... I changed it this time, but next time you may receive an infraction.

[krabople]

That's great, thanks very much to both of you for your help.

Sorry about the thread title, I'll make sure I'm more descriptive in future.

[royUK]

You might not have a PERSONAL.xls, if not try recording a macro and in the "store macro in" drop down select PERSONAL.xls.

An alternative would be to create an excel addin.

[krabople]

Do you have any good sources of information regarding creating addins?

[VBA Noob]

See if links help

http://www.fontstuff.com/VBA/vbatut03.htm
http://www.ozgrid.com/VBA/excel-add-in-create.htm

VBA Noob

[krabople]

They look perfect, thanks Noob