about worksheet

[jp]

hi
need help!
how to create a worksheet that the half is a read only cannot be change by
other user and the other half is a full control.

 

[Tom Ogilvy]

Click on all cells and do Format => Cells, select the protection tab and
make sure Locked is checked.

Now select the cells you want to allow the user to control

do Format=>Cells and select the protection tab and make sure Locked is not
checked.

Now do Tools=>Protection=>Protect =>Protect sheet. If using xl2002 or
later, you will have a lot of options available as to what you allow users
to do. In earlier versions, protecting the sheet imposes a lot of
restrictions, so you can't have full control.

The only alternative to locking/protecting is to manage user access with
code, but if the user disables macros, you have lost all that control.

Maybe the best answer would be to use two sheets - one visible and available
to the user and the other hidden.