Why not set up one and copy that one for each new week or have all one ONE
sheet and filter the week or record a macro while doing it manually and use
that macro (cleaned up) to set up each sheet or select all sheets and do the
setup.
--
Don Guillett
SalesAid Software

"Thom" wrote in message
...
I have data on a worksheet for each week of the year i.e tab 1 is week 1
tab2
is week 2 and so on until week 52. I need to set the whole worksheet to
print them all in the same format. I am currently changing eack week in
the
page setup box manually. Is there a way to set the whole worksheet to
print
in the same style and margins etc..

Many thanks to anyone who can help me.
--
Thom