| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
security - protecting a worksheet
I have protected worksheets that I need users to update. (I unlocked the
cells that I want them to use and kept the rest locked; then protected it.) When certain sheets are activated, I want them to be sorted but excel will not allow it once I protect the sheets. I unchecked the "sort" button in the security box but it still will not allow the sort. (I also tried allowing insert rows and columns and it's as if I didn't bother.) Am I doing this wrong somehow or misinterpreting what these buttons allow? HELP!! Thanks! Paula |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
security - protecting a worksheet
Sort refers to the column/row sort.
-- If this post helps click Yes --------------- Jacob Skaria "paulas" wrote: I have protected worksheets that I need users to update. (I unlocked the cells that I want them to use and kept the rest locked; then protected it.) When certain sheets are activated, I want them to be sorted but excel will not allow it once I protect the sheets. I unchecked the "sort" button in the security box but it still will not allow the sort. (I also tried allowing insert rows and columns and it's as if I didn't bother.) Am I doing this wrong somehow or misinterpreting what these buttons allow? HELP!! Thanks! Paula |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
security - protecting a worksheet
From what I've been reading, if any cell in the sheet is "locked", you cannot
sort at all. I don't understand this but it seems to be the case. Thanks! "Jacob Skaria" wrote: Sort refers to the column/row sort. -- If this post helps click Yes --------------- Jacob Skaria "paulas" wrote: I have protected worksheets that I need users to update. (I unlocked the cells that I want them to use and kept the rest locked; then protected it.) When certain sheets are activated, I want them to be sorted but excel will not allow it once I protect the sheets. I unchecked the "sort" button in the security box but it still will not allow the sort. (I also tried allowing insert rows and columns and it's as if I didn't bother.) Am I doing this wrong somehow or misinterpreting what these buttons allow? HELP!! Thanks! Paula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Customized worksheet security | Excel Discussion (Misc queries) | |||
| Worksheet Security | Excel Discussion (Misc queries) | |||
| Worksheet Security Breaker | Excel Discussion (Misc queries) | |||
| Worksheet Security | Excel Discussion (Misc queries) | |||
| worksheet security | Excel Discussion (Misc queries) | |||
Linear Mode
