Dear Mr. Paul
Thanks for the response.
Need one more help.
I have 2 worksheet in one file and both are linked to each other. I did the
same as explained by you and was successful. Now for the second worksheet,
if i need to lock only one coloum and unlock the second coloum, is it
possible?
E
The steps would be:1) Select all cells Right-Click and select "Format Cells"
go to "Protection" tab and make sure "Locked" is selected. Select "OK"2)
Select all cells you want to be able to select/change Right-click and select
"Format Cells" on "Protection" tab, DE-SELECT the "Locked"
