LinkBack URL
About LinkBacks
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?
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?
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes, trying to sort using auto filter and manually. See attached test file.
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
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.
Interesting but probably not surprising ;-)
Try setting the sort options manually before protecting
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks