Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect worksheet but allow users to use specific columns/cells
how do I protect the worksheet but allow users to change the values in
specific column/cells? Specifically, I want to protect a worksheet so changes can't be made to anything but the "quantity" column. Thanks in advance for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect worksheet but allow users to use specific columns/cells
Hi,
Select the cells you want the users to have access, then right click in the mouse, cell format, go to the last tab = Protection and uncheck locked, then protect your worksheet and done if this helps please click yes, thanks "mexpedip" wrote: how do I protect the worksheet but allow users to change the values in specific column/cells? Specifically, I want to protect a worksheet so changes can't be made to anything but the "quantity" column. Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect cells from other users w/out me having to enter pw | Excel Discussion (Misc queries) | |||
share specific columns with other users | Excel Worksheet Functions | |||
Protect a worksheet, but allow ONLY specific users to change info | Excel Worksheet Functions | |||
How can I protect cells and allow users to insert/delete | Excel Worksheet Functions | |||
How can I protect Excel Worksheet and allow users to UnGroup Data | Excel Worksheet Functions |