Forum Discussion
LuisEmilio
Aug 04, 2022Copper Contributor
I can't sort (ascendent/descendent) data in a protcted sheet even thou I set SORT option enable
Hi everyone. I have a protected sheet and I had set 2 options to use: Autofill and Sort. Users that access can use Autofiltering but when they try to sortering in a way (ascendent / descendent) app...
LuisEmilio
Aug 05, 2022Copper Contributor
Thank you Riny_van_Eekelen for your answer.
Following your instructions, it means I can protect sheet but anyone can modify any cell.
What I need is protect cells for not being modified while sheet is protected. Meanwhile users can autofiltering and sort range/table. All about this is with sheet protected.
Regards.
Riny_van_Eekelen
Aug 05, 2022Platinum Contributor
LuisEmilio That's not possible then.