Is it possible to sort a protected worksheet?

P

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

Frank Kabel

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

Phyllis

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

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.)
 
D

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.
 
M

mnbv

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)

Dana DeLouis said:
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.
Click to expand...
 
M

mnbv

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

mnbv said:
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)
Click to expand...
 
Top