My own function cannot be exported.

Hi.

Sorry if this is the wrong NG. If so, please inform me of the correct
one.

Ok. To the problem: I have made a function in VB and put it in a *.xla
in order to be able to access the function each time I open a new
workbook. And it works fine. But when I want to distribute my
workbook, the function is no longer available. If I then put the
function in a VB connected to the local workbook, I still need to
remove the module that I first made (the one that is saved in the
*.xla file). And when I do that, the problem STILL is there. And that
is even when the function actually is available to the workbook.
First when I re-type the calculation that uses the function I can get
the workbook to read the function where I want it to be read: at the
local workbook.


Of course I could export the module and ask the user to place the
module in a folder with the same destination as the one my *.xla is
in, but that is not very user friendly.

Isn't there an easier way of exporting a workbook that contains the
same functions locally as globally and having it collecting the
function where it can?