Reply to thread

Message: [QUOTE="jraonline, post: 14127322"] 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 greaty appreciated. Thanks! John [/QUOTE]