Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protected cells
Hello.
Is it possible to protect selected but discontinuous cells in a worksheet? for example i would like to protect cells A1:A3, B10 and M4:M24 Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protected cells
You can *lock* any cells you want. Then you have to protect the worksheet
for the locking to be effective. All cells are locked by default. You need to select all the cells on the worksheet, unlock them (Format | Cells | Protection), lock the specific ones you want (same methodology) and then protect the worksheet. -- Vasant "Iconoclast" wrote in message ... Hello. Is it possible to protect selected but discontinuous cells in a worksheet? for example i would like to protect cells A1:A3, B10 and M4:M24 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
protected cells | Excel Worksheet Functions | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Protected cells | Excel Discussion (Misc queries) | |||
Tab down instead of right in protected cells | Excel Discussion (Misc queries) |