Lock spreadsheet but can sort
I am working on a template. I'd like to lock my spreadsheet so others who
use this template can't change the formula inside, but I'd like to make the
sorting feature available. Is there a way to do this?
When I go to Tool Protection Protect Sheet, it also disable the sorting
feature in Excel.
Any help or advice?
Thanks,
GU
|