Worksheet name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

donh - 17 Nov 2006 14:19 GMT

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

Reply to this Message

Jenn - 17 Nov 2006 14:52 GMT

> Hi,
>
[quoted text clipped - 12 lines]
>
> DonH

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

Reply to this Message

donh - 17 Nov 2006 15:02 GMT

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

> > Hi,
>
[quoted text clipped - 23 lines]
> Have a great day!
> Jenni- Hide quoted text -- Show quoted text -

Reply to this Message

Jenn - 17 Nov 2006 15:18 GMT

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

> Thanks for your reply, Unfortunatley its not a very straight forward
> case. The workbooks that will be created cover yearly shift patterns
[quoted text clipped - 37 lines]
> > Have a great day!
> > Jenni- Hide quoted text -- Show quoted text -

Reply to this Message

Bob Phillips - 17 Nov 2006 15:22 GMT

What are the rules for determining the names?

Signature

HTH

Bob Phillips

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

Reply to this Message

donh - 17 Nov 2006 16:22 GMT

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

> What are the rules for determining the names?
>
[quoted text clipped - 46 lines]
> > > Have a great day!
> > > Jenni- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

Reply to this Message

donh - 18 Nov 2006 08:39 GMT

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

> Bob,
>
[quoted text clipped - 77 lines]
> > > > Have a great day!
> > > > Jenni- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

Reply to this Message