| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
By the way it is excel 2003 I'm working with.
"Sue" wrote: I have a workbook that has some cells locked/hidden and the worksheets protected, because I don't want my formula's messed with. However there are other cells where a user (not me) will input data and need to sort it into alpha or date of birth order, but they can't due to the sheet being protected. The unlocked cells box has been checked of course in the tools/protection window before passwording and I have checked the sorting box as well so... why won't it let it be sorted. It comes up with sheet is protected, read only, need to remove protection to get it to sort. But if I remove the protection I run the risk of someone deleting my formula's. Can anyone help? Why is there a selection of boxes to check what you want to allow to have happen once protected, if you can't do it. I know the unlocked cells one works once the sheet is protected so why not sort? What am I doing wrong? The only thing I do is the template, no data imputing and due to the user's level of competency it is too risky to leave formula's exposed. It is not a shared workbook by the way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert comment in protected worksheet | Excel Worksheet Functions | |||
| Import/Export XML in protected worksheet | Excel Discussion (Misc queries) | |||
| Question about sorting in protected worksheet | Excel Worksheet Functions | |||
| Sorting protected worksheet | Excel Discussion (Misc queries) | |||
| How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions | |||
Threaded Mode
