Since I am working on creating templates for a company that is going to be needing to edit these templates in the future, I'd like to have a way to not include the macros in the actual template itself but instead create a separate document with all the macros for all the templates in it (sort of my like own Personal.xls would be) but include an extra macro that will automatically move all of these macros to the users own Personal.xls when they open it (or maybe click a button).

I don't know what would be involved in order to create this, especially considering the fact that some users may have deleted their Personal.xls in the past or many other things could have happened.

I would think the best way to do this would be to somehow have the macro create a new workbook, name it something like "Clothing_Template_Macros.xls" and save it it to their startup folder with the macros in it...can this be done without knowing the exact location of their startup folder?

And on top of all that, I was hoping for it to have an attached toolbar with buttons linking to the different macros...but I would assume it has to know where this workbook is going to be located for it to link correctly.

Anybody ever tried to do something like this before?

Is this all just a pipe dream?