Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How to protect a column?
Hi! I would like to protect some hidden columns. When I choose "protection" in the menu, I only find the possibility to define area to be modifed but I would like to do the opposite: define which areas canīt be modified. How can I do this? Thanks. -- xpucto ------------------------------------------------------------------------ xpucto's Profile: http://www.excelforum.com/member.php...o&userid=23748 View this thread: http://www.excelforum.com/showthread...hreadid=374127 |
#2
|
|||
|
|||
Is there some kinf of options to protect all hidden columns? Or to protect functions? -- xpucto ------------------------------------------------------------------------ xpucto's Profile: http://www.excelforum.com/member.php...o&userid=23748 View this thread: http://www.excelforum.com/showthread...hreadid=374127 |
#3
|
|||
|
|||
Cells are locked or unlocked.
Worksheets are protected or not protected. If you lock all the cells you want to stop changes, then protect the sheet, won't you have what you need? In xl2002+, you can allow some users (who know a password) to change certain ranges. But I don't see how that would affect any locked cell on a protected sheet (if you didn't use this extra granularity feature). xpucto wrote: Hi! I would like to protect some hidden columns. When I choose "protection" in the menu, I only find the possibility to define area to be modifed but I would like to do the opposite: define which areas canīt be modified. How can I do this? Thanks. -- xpucto ------------------------------------------------------------------------ xpucto's Profile: http://www.excelforum.com/member.php...o&userid=23748 View this thread: http://www.excelforum.com/showthread...hreadid=374127 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Is there a way to password protect a column? | Excel Discussion (Misc queries) |