allow custom sort on protected sheets

[rjmdc]

i need to enable the "custom sort" option on a protected sheet that will allow both locked and unlocked cells to be sorted
how can i do that?

 

[Fluff]

I'm afraid that you cant. You can only sort unlocked cells.

 

[rjmdc]

what macro can i add to allow custom sort or impossible?

 

[Fluff]

You can do it via code as long as the sort columns & criteria are always the same.

 

[rjmdc]

that wont work

 

[EXCEL MAX]

If you are trying to do that without VBA you need to combine:
1. Lock or unlock wanted cells
2. Use "Allow user to edit range" in the protection
3. Finally, when you protecting sheet select only this checkboxes:
-Select unlocked cells
-Sort
-Use AutoFilter

 

[rjmdc]

that doesnt work for custom sort
vba wont work bcecause custom sort is different sort columns and parameters each time

 

[EXCEL MAX]

In the custom sort panel, check "My Data has headers".
If the filter is applayd in the header this checkbox automaticly become disabled (Be careful).
Try to include headers in sorting range. This may cause problem if it's not included.

1. Lock or unlock wanted cells
2. Use "Allow user to edit range" in the protection. Include header in the range.
3. Finally, when you protecting sheet select only this checkboxes:
-Select locked cells
-Select unlocked cells
-Sort
-Use AutoFilter

 

[Fluff]

2. Use "Allow user to edit range" in the protection. Include header in the range.

Surely that will allow users to edit locked cells?

 

[EXCEL MAX]

Ha, ha, ha. Now I see the point. Yes Fluff, you are right.
I don't see the way to do that without VBA.
I didn't know that option "Allow user to edit range" cancels locked cells property.