I recently deployed a single-page spreadsheet intended to be added to existing workbooks (it generates a hiearchical view of pricing in a WBS structure), and it includes some UDFs and subs.
I was hoping I could save it as a tempate, but when inserted as a template, it didn't bring along its code module. I ended up instructing someone to copy the sheet to the intended workbook, and had them open the VBE to drag the module over. There is surely a better way!
I would prefer not to train people to use add-ins or mess with Personal.xls.
Thanks in advance for your suggestions.