I have a workbook kept on a shared server. In one worksheet, there are multiple formulas that need to be protected. However, if I protect the worksheet - then users are unable to sort the data.
I've looked up multiple topics on this - but nothing seems to be working. Can I protect certain columns from being modified for some users without protecting the worksheet? If I protect it and select "Allow all users to select cells and sort" it still will not allow the sort.
Please help. I don't know how to write macros - otherwise I would make a "sort by" button that I've read about.
Thanks in advance.
I've looked up multiple topics on this - but nothing seems to be working. Can I protect certain columns from being modified for some users without protecting the worksheet? If I protect it and select "Allow all users to select cells and sort" it still will not allow the sort.
Please help. I don't know how to write macros - otherwise I would make a "sort by" button that I've read about.
Thanks in advance.