Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock cells
Hi,
I have an excel file with 5 sheets and on each sheet some data. I would like to avoid people to see some sheets. For example, they can only see "sheet4". Moreover, i would like to lock or restrict their rights. They should be able only to update a range of cells (ex: B6:C50) how can i do that ? thanks a lot, Al. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock cells
Alain,
Hide sheets 1,3 & 5 with format - sheets - hide and apply a password if you wish. For sheet 4 select all the cells you want users to edit and click format - cells protection and remove the locked checkmark. Then protect to sheet with tools - protection - protect sheet and apply a password. Just one note of caution XL protection is not very robust and can be easily cracked. Mike "--== Alain ==--" wrote: Hi, I have an excel file with 5 sheets and on each sheet some data. I would like to avoid people to see some sheets. For example, they can only see "sheet4". Moreover, i would like to lock or restrict their rights. They should be able only to update a range of cells (ex: B6:C50) how can i do that ? thanks a lot, Al. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock cells | New Users to Excel | |||
Lock Cells | Excel Discussion (Misc queries) | |||
why do some cells not lock? | Excel Discussion (Misc queries) | |||
lock cells. | Excel Discussion (Misc queries) | |||
Lock all cells? | Excel Discussion (Misc queries) |