Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am making a utility to share with a group of friends. I am trying to lock
it down and idiot-proof it so it cannot be edited or corrupted. I see in the Worksheet Protection list there are options for users to be permitted to Auto Filter and to Sort. If I protect the sheet the Auto Filter still works fine but the Sort does not. Is this a known bug? Why have Sort as an option in the list if it doesn't work?? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It is not a bug. When you sort the data, you are changing the values of each
individual cell (just moving it somewhere else). Thus, the cells that you want sorted would need to be unprotected. If you do not allow sorting when you protect the sheet, you would not be allowed to sort the unprotected data. If you are needing to lock something down that well, I would recommend making it read-only (with a password required?). In the battle between programmers trying to foolproof things, and the universe making a better idiot, the universe usually wins. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Topgun505" wrote: I am making a utility to share with a group of friends. I am trying to lock it down and idiot-proof it so it cannot be edited or corrupted. I see in the Worksheet Protection list there are options for users to be permitted to Auto Filter and to Sort. If I protect the sheet the Auto Filter still works fine but the Sort does not. Is this a known bug? Why have Sort as an option in the list if it doesn't work?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting a protected worksheet | Excel Worksheet Functions | |||
macro for sorting in protected sheet | Excel Discussion (Misc queries) | |||
Sorting a protected sheet | Excel Worksheet Functions | |||
sorting protected sheets | Excel Worksheet Functions | |||
Sorting protected worksheets | Excel Discussion (Misc queries) |