Sorting in a protected sheet

T

Topgun505

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??
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting whole Protected 2003 REDUX 0
Sorting while protected - this question may not have been covered. 1
Sorting in a protected cell (Excel 2007) 0
Sorting tables on protected worksheets 7
Sorting a sheet in VBA 2
Cannot sort a table containing text 5
Macro & Protected sheet 2

Top