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?