Using functions in personal.xls

[Lorne]

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?

 

[Tom Ogilvy]

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.