Excel Template naming option.....
 

I have a question......

I used to be able to set-up an Excel template to "auto-name" the worksheet
when I clicked "Save As". I had a certain cell in the worksheet that
contained the work order number that I was working with. But now, I can't
remember how to set up the template to "Save As" the contents of that cell.

Please help........

Dave

Excel Template naming option.....
 

This has never been a selectable option in Excel when creating workbooks
from a Template.

You most likey had some VBA event code that did the deed.


Gord Dibben MS Excel MVP

On Wed, 26 Aug 2009 14:58:01 -0700, Turbine Mechanic
wrote:

I have a question......

I used to be able to set-up an Excel template to "auto-name" the worksheet
when I clicked "Save As". I had a certain cell in the worksheet that
contained the work order number that I was working with. But now, I can't
remember how to set up the template to "Save As" the contents of that cell.

Please help........

Dave