Morning all,

So far I have managed to insert a new worksheet from a hidde
'template'; unhide it and through a UserForm, change the name of tha
worksheet; in addition I have managed to place the name of th
worksheet in a given cell (worksheets are indiviualised to staf
members and I need their name to appear for a formula to work) - so fa
so good!

My problems are two fold;

1. I need the worksheet name to appear in the header when printing (th
user's name) but no matter how I try I can't get it to work, here is m
line of code:

.CenterHeader = _
"&""Arial,Bold""&11Sheet name here!" & Chr(10) & "" & Chr(10)
"&10POther text here"

This obviously places 'Sheet name here' as the first line of the heade
and I need the ActiveSheet.Name to appear!

2. I collate all remaing worksheets into one called 'Master' and
have another worksheet hidden called "Template".

Currently I use the following code to collate the remainin
worksheets:

'loop thru an array of sheets
For Each wsSrc In wb.Worksheets( _
Array("Carrie", "Dave", "Eileen", "Geraldine", "Jabeen", "Jackie"
"Julie", "Pauline", "Rebecca"))
'alt: array(2,3,4,5)

How do I add additional sheets to this when they are created i.e sa
one called "Joe"

Sorry for the long post but I only need to have these cracked for m
project to work much better! (always enhancing :) )

Thank you,

Dav

--
deele
-----------------------------------------------------------------------
deelee's Profile: http://www.excelforum.com/member.php...fo&userid=3486
View this thread: http://www.excelforum.com/showthread.php?threadid=55639