Is it possible to "Allow" Sorting and use of Autofilter with respect to Locked cells when the worksheet is Protected? Even though I have checked both 'Sort' and 'Use Autofilter' under the "Allow all users of this worksheet to:" options list, when enabling protection, I am not able to perform either operation when the target cells are Locked.
If I set the cells to be sorted or filtered to be Unlocked then it works just fine when the worksheet protection is enabled.
I have "read" that by selecting the appropriate "Allow users to ...." option the desired functionality should work with respect to target cells that are set to the Locked status - what do I need to do differently?
Any guidance would be greatly appreciated.
Bookmarks