Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |