C
Clif McIrvin
xl2010
I have several different templates for a variety of commonly used
workbooks.
I have also developed a utility worksheet -- somewhat of a dashboard, of
sorts -- that is generic enough it works in any workbook.
At first, I simply placed a copy of that utility worksheet in each
template ... but sooner of later I find a reason to modify that utility
template; and that requires manually changing every template.
Is there a way to put a pointer to another template in a template so
that whenever the primary template is used to create a new workbook it
automagically adds the secondary template sheet to the new workbook?
I've been tinkering with putting code behind the primary template's open
event to add that secondary template/worksheet, and got to wondering if
Excel already had that ability and I just didn't know about it.
Comments?
Suggestions?
I have several different templates for a variety of commonly used
workbooks.
I have also developed a utility worksheet -- somewhat of a dashboard, of
sorts -- that is generic enough it works in any workbook.
At first, I simply placed a copy of that utility worksheet in each
template ... but sooner of later I find a reason to modify that utility
template; and that requires manually changing every template.
Is there a way to put a pointer to another template in a template so
that whenever the primary template is used to create a new workbook it
automagically adds the secondary template sheet to the new workbook?
I've been tinkering with putting code behind the primary template's open
event to add that secondary template/worksheet, and got to wondering if
Excel already had that ability and I just didn't know about it.
Comments?
Suggestions?