about worksheet
 

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.

about worksheet
 

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.

--
Regards,
Tom Ogilvy


"jp" wrote in message
...
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.