dnewman33
asked on
sort enabled on protected sheet
What is the point of letting me enable sorting and autofilter in excel 2007 under the protection in the sheeet tab. Sure it lets me click on the filter button and select a method, but then it comes back and says protected.
test-EE.xlsx
test-EE.xlsx
ASKER
I know they are locked. I want data sortable, but safe. I created 2 macro buttons to lock and unlock after sorting by people that don't know excel at all.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This function/feature works if cells are unlocked...