ExcelBanter - copy-past and lock cel!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - copy-past and lock cel! (https://www.excelbanter.com/excel-programming/372120-copy-past-lock-cel.html)

albatros

copy-past and lock cel!

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

Ian

copy-past and lock cel!

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

All times are GMT +1. The time now is 05:34 AM.