Is it possible to sort a protected worksheet?

[Phyllis]

I have a worksheet that I've protected all the cells that
contain formulas so that other user's can't inadvertently
delete them. However, I need to be able to sort the data,
but it's not an option when the sheets protected. Any
suggestions?

 

[Don Guillett]

turn on macro recorder
unprotect
sort
protect

 

[Frank Kabel]

Hi
only possible using VBA (first unprotecting the sheet, then sorting and
protecting the sheet again)

 

[Phyllis]

Thanks. I tried that and I get a message that the project
is locked, and it won't record the macro.

 

[Frank Kabel]

Hi
o.k. then you first have to unprotect your workbook

 

[Dave Peterson]

Unprotect the project in the VBE--not unprotect the workbook in excel.

(In the OP's other thread, the thought of a Shared workbook was discussed, too.)

 

[Dana DeLouis]

I have a worksheet that I've protected ...

Don't know if this would apply, but in the latest versions of Excel, when
you go
Tools | Protection | Protect Sheet
you can select "Allow all users of this worksheet to:"
and select "Sort", which is nearer the bottom of the list.

 

[Guest]

does selecting 'sort' work?

in the protect menu i have ticked 'autofilter' and i can use autofilter, and
i have ticked 'sort', but i can't use sort - is this a bug, or am i missing
something? (using excel 2002)

Don't know if this would apply, but in the latest versions of Excel, when
you go
Tools | Protection | Protect Sheet
you can select "Allow all users of this worksheet to:"
and select "Sort", which is nearer the bottom of the list.

 

[Guest]

i think i know what i was missing - you can't sort (but can filter) locked
cells

does selecting 'sort' work?

in the protect menu i have ticked 'autofilter' and i can use autofilter, and
i have ticked 'sort', but i can't use sort - is this a bug, or am i missing
something? (using excel 2002)