Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting Access to Parts of worksheet
I have a worksheet in Excel 2003. I have 7 users of this sheet and only want
them to be able to update cells relevant to them. I tried Protection/Allow Users to edit etc. but any help much appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting Access to Parts of worksheet
First you need to select all the cells in the workbook, and format cells,
protection, and uncheck the box marked "locked". Then select the cells you want locked, and format cells, protection, locked. Then you can protect your workbook. Steve "confused from Ireland" wrote: I have a worksheet in Excel 2003. I have 7 users of this sheet and only want them to be able to update cells relevant to them. I tried Protection/Allow Users to edit etc. but any help much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing parts of worksheet | Excel Worksheet Functions | |||
Restricting access to a range of cells | Excel Discussion (Misc queries) | |||
restricting access to a worksheet? | Excel Discussion (Misc queries) | |||
Restricting Multi-user access | Excel Worksheet Functions | |||
How to hide parts of worksheet | Excel Discussion (Misc queries) |