Excel 2007 : Can't sort on protected sheet

[mcmuney]

I've protected the header of my sheet and unlocked all the data rows and protected the sheet with both sort and auto filter options checked. But when I try to sort, I get the protection dialogue box. What am I missing?

[TMS]

Can you post a sample workbook? Ideally, the real thing but with test data and which demonstrates the problem.

I take it you are trying to sort manually, not through VBA?

Regards

[mcmuney]

Yes, trying to sort using auto filter and manually. See attached test file.

[TMS]

Well, there's good news and bad news. The good news is you have choices.

The bad news is that, if you want to retain the locked header cells, the solution is a VBA macro that unprotects the sheet, does the sort and re-protects the sheet.

Or, if you unlock the locked header cells, you can indeed sort your protected worksheet.

Bit of a let down really but I'm sure there's some logic behind it ... though, what it is, I do not know.

Regards

[mcmuney]

I'm able to use a VBA macro to sort without unprotecting and reprotecting it. This seems to be a bug as there's an option to allow for sorting when protecting a sheet.

[TMS]

Interesting but probably not surprising ;-)

[royUK]

Try setting the sort options manually before protecting