UDFs/Macros in workbook

[Brian Tozer]

I am confused concerning where UDFs and/or macros must be located so that
they will available to someone that I send the workbook to.
Can they be in an add-in?
Can they be in my Personal.xls file?
Must they be in a module of the workbook?

Thanks
Brian Tozer

 

[Gord Dibben]

Brian

UDF's and Macros can reside in a General Module in the workbook you send.

They could be in an Add-in which you would also send.

Personal.xls is not a great idea since you would have to send that along with
the workbook and the user may have his/her own Personal.xls which you would
not want to overwrite or cause conflicts with.

Gord Dibben Excel MVP

 

[Brian Tozer]

They could be in an Add-in which you would also send.

Thanks Gord.
Would this require sending the xla file as a seperate file that the user
would have to save in the correct place on their HD, or could it be
incorporated into the .xls file somehow?
I assume the former, so it seems that the obvious solution is to include
them in a module in the workbook and keep add-in and Personal.xls components
for the ones that only I will use.
Right?

Thanks for your help as always.
Brian Tozer

 

[Gord Dibben]

Brian

In-line..........

Thanks Gord.
Would this require sending the xla file as a seperate file that the user
would have to save in the correct place on their HD, or could it be
incorporated into the .xls file somehow?

Add-in sent as well as workbook. Saved in correct place on their HD.

I assume the former, so it seems that the obvious solution is to include
them in a module in the workbook

If the macros are only for that particular workbook, leave them with the
workbook. Just make sure there are no hard-coded pathnames in any routines
that would have to be adjusted by the users.

and keep add-in and Personal.xls components
for the ones that only I will use.
Right?

That's the route I would use.

Thanks for your help as always.
Brian Tozer

Gord