This is an update to my original post with better information, I hope.
I have two different workbooks open. Workbook A = Master Template, Workbook B = Add on for Template.
Users import the B Workbook into the Master. To keep formatting, I'm using PasteSpecial Columnwidths, then a Paste into the A Workbook.
But then I need to export any custom VBA modules from Workbook B, then import then into WorkBook A.
Personal Workbooks are out of the question, since not every user will need every macro.
Any suggestions out there.
I have two different workbooks open. Workbook A = Master Template, Workbook B = Add on for Template.
Users import the B Workbook into the Master. To keep formatting, I'm using PasteSpecial Columnwidths, then a Paste into the A Workbook.
But then I need to export any custom VBA modules from Workbook B, then import then into WorkBook A.
Personal Workbooks are out of the question, since not every user will need every macro.
Any suggestions out there.