Not tested, but try Copy & Paste, then Paste SpecialFormats

--
Ian
--
"albatros" wrote in message
...
I have a problem.

a have a workcalender.
This is weekly.

So i need 52 weeks.

Now i have 1 week in 1 sheet.
To make it easy, i copy the sheet every time.
But i have 1 problem.

A few cels have to be lockt.
But every time i caopy my sheet, thos cels are onlock.

How can i solve this.

TIA