Sharing worksheets with custom functions

  • Thread starter Thread starter jimlyke
  • Start date Start date
J

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
 
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
 
Back
Top