Excel Template naming option.....

[Turbine Mechanic]

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

 

[Gord Dibben]

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