Sharing worksheets with custom functions

[jimlyke]

What is the easiest way to share spreadsheets with custom
functions? If I only send the sheet, they won't have the
custom functions. If I send the sheet and add-in, it's
usually too hard to explain that they have to put in the
AddIns folder. I'm sure there must be an easier way.

jim

 

[Bernie Deitrick]

Jim,

Put the custom functions in a module in the worksheet. Then it will
be self-contained: harder to update the functions, but easier to
distribute.

HTH,
Bernie