Worksheet name

D

donh

Hi,

I posted to this group earlier but it hasn't shown up so I'm trying
again.

I need to update worksheet names that appear on the tabs when a new
workbook is created from a template I've created.

Is there any way that this can be done automatically dependent on data
selected when the sheet is setup.

Making the changes to each sheet manualy is not a desirable option.

Thanks in anticipation.

DonH
 
J

Jenn

donh said:
Hi,

I posted to this group earlier but it hasn't shown up so I'm trying
again.

I need to update worksheet names that appear on the tabs when a new
workbook is created from a template I've created.

Is there any way that this can be done automatically dependent on data
selected when the sheet is setup.

Making the changes to each sheet manualy is not a desirable option.

Thanks in anticipation.

DonH
Click to expand...



Hi Don,
Why not edit the template with the tab names you want to have. So when
you create a new workbook based on the template - they will
automatically be there?

Or you could set up a macro to run automatically when you open the
workbook. Record a macro to change names of Sheet1, Sheet2 and Sheet3.
Save it to "that workbook only". Hope that helps. It's hard to
explain this by typing.

Have a great day!
Jenni
 
D

donh

Thanks for your reply, Unfortunatley its not a very straight forward
case. The workbooks that will be created cover yearly shift patterns
which are not the same each year. For example one monthly (which is
actualy 5 weeks) sheet will have the name of Feb-Apr, the following
yeat it will be called Mar-Apr.

I have a lot of formulas providing reports from these sheets and really
don't want to leave it to chance that they are renamed in the right
order.

Hope that helps a little more and thanks as always for any suggestions.

DonH
 
J

Jenn

It sounds as if you need to create a new workbook for each year. You
have me stumped on this one.
 
B

Bob Phillips

What are the rules for determining the names?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

donh

Bob,

I have got a piece of VBA that checks for the following names to ensure
views set (compiled from a previous post) are only used in the correct
situation, these names represent the variants of period for the next 10
years. I have lookups that automatically set the shift pattern and
month start end points for these years and I was hoping that I could
use something similar to set cell values which could be read and the
named sheets ammended accordingly

Case "Jul_Sep"
Case "Mar_May"
Case "Jun_Aug"
Case "May_Jul"
Case "Jan_Mar"
Case "Apr_Jun"
Case "Nov_Jan"
Case "Feb_Apr"
Case "Jan_Feb"
Case "Feb_Mar"
Case "Mar_May"
Case "May_Jun"
Case "Jun_Jul"
Case "Aug_Sep"
Case "Oct_Nov"
Case "Dec_Jan"

Many thanks

DonH
 
D

donh

Hi,

Just thought I would say I've thought of a work around by using
hyperlinks. I've created a switchboard and use a hyperlink cell linked
to my lookup cell (which sets the 5 weekly period for the year, as
below), this allows me to hyperlink to a constant worksheet using a
variable name.

If anyone has a non hyperlink way then I would still be interested.

Many thanks

DonH
 
Top