Lock cells

Posted by Loon on January 28, 2002 6:48 AM

Ho can I hide the code behind the cells and still allow the worksheet to be usabel to input data

Also I would like the first 20 Cells to be visable so that when scrollling down the page the first 20 rows stay at the scroll works from 20 onwards

Reason being the first 20 rows contain instructions hgeadings etc

Thanks

Posted by Ivan F Moala on January 28, 2002 7:02 AM

Select all your formula cells
Do this via > Edit > goto > special
Then select Formulas

Now Format > Cells
Select the Properties tab
click the hidden option
Click OK

Now protect your sheet
Your formula cells will remain hidden
as long as your sheet is protected.

NB: change your data | input cells to unlocked

Select A21 goto Windows > select freeze panes
Are you sure all 20 rows will be visible ?
if not change screen resolution....

HTH

Ivan