Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock cells without protecting sheet?
Is there a way to lock (or something like it) cells in a sheet without
protecting the whole sheet? I've got some cells that need to locked from users changing the formulae, but cannot protect the sheet because I'm also using the outlining feature (grouping) to expand and collapse rows. I guess an alternative question would be....is there a way to use the outlining feature in a protected sheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
My sheet is unprotected, but I can't format cells. | Excel Discussion (Misc queries) | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |