[creating templates for all sheets]

I have created a template but the only sheet that shows my template is sheet
1. How do I get all the other sheets to automatically be like sheet 1 of the
template? I can copy the sheets but I want them to automatically have the
format as saved when I created the template.

[Jay Freedman]

On Fri, 4 Sep 2009 14:35:01 -0700, creating templates for all sheets
creating templates for all wrote:

I have created a template but the only sheet that shows my template is sheet
1. How do I get all the other sheets to automatically be like sheet 1 of the
template? I can copy the sheets but I want them to automatically have the
format as saved when I created the template.

Try asking your Excel question in an Excel newsgroup.
http://www.microsoft.com/office/comm...t.public.excel
or
http://www.microsoft.com/office/comm...lic.excel.misc

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.