Using functions in personal.xls
 

I have a number of bespoke functions stored in personal.xls that I use
regularly.

Whenever I send a spreadsheet to a third party I have to look/remember
whether any of these are in use. If they are I copy them to a workbook
module & change the reference in the formula from personal.xls to the
workbook.

Is there a way to tell Excel to look for non standard functions and
automatically put them in the workbook so the spreadshhet can work on any
machine?

Using functions in personal.xls
 

No there isn't any built in option. You would have to write code to do it.

http://www.cpearson.com/excel/vbe.htm will give you some information on
programming the VBE.


--
Regards,
Tom Ogilvy

Lorne wrote in message
...
I have a number of bespoke functions stored in personal.xls that I use
regularly.

Whenever I send a spreadsheet to a third party I have to look/remember
whether any of these are in use. If they are I copy them to a workbook
module & change the reference in the formula from personal.xls to the
workbook.

Is there a way to tell Excel to look for non standard functions and
automatically put them in the workbook so the spreadshhet can work on any
machine?