How do I sort protected cells?

S

Stephen238

When I apply protection to my sheets, the prompt offers to allow sorting of
protected cells, but even when I check that box, it won't work. I can get it
to allow almost everthing else on that list of choices for protected cells,
but no sorting....thoughts?
 
D

Dave Peterson

Do you have any locked cells in the range you want sorted?

Are you selecting just the unlocked cells that should be sorted?
 
S

Stephen238

I believe that they are still locked, but that's kind of the problem. The
entire sheet is data which I would like to be able to sort....but which I'd
like to give to other people and not allow them to modify it.
 
D

Dave Peterson

The only way I know to sort locked cells on a protected sheet is to unprotect
the sheet first.

Maybe you could give them a macro that
unprotects the worksheet
sorts the data (the way you want!)
reprotects the worksheet

(or give them a couple of macros to provide optional sorts.)
 
K

Kim

Dave: I am having this problem. I am going to have to record a macro. Our
sheet is password protected and when I run the macro, the user is prompted to
enter the password (which they do not know). Is there a way to bypass the
password protection other than protecting the sheet without a password?
Thanks.

Kim
 
G

Gord Dibben

Kim

See one possible solution to the password problem in your other posting
"Custom Filter that Displays.........."


Gord Dibben Excel MVP

Dave: I am having this problem. I am going to have to record a macro. Our
sheet is password protected and when I run the macro, the user is prompted to
enter the password (which they do not know). Is there a way to bypass the
password protection other than protecting the sheet without a password?
Thanks.

Kim
Click to expand...
 
Top