Forum Discussion
How to Enable Sorting while Protecting Formulae
I have a workbook which lists people on 4 matching tabs (let's say: Potential, Accepted, Not Accepted, Completed). There are some columns with formulae that I want protected from damage by less-knowl...
Thanks. Your first two sentences tell me what I want Excel to do - it won't do. Which is frustrating.
Not sure why you went on in detail describing what I've already done... LoL.
According to the message (in your first post), you should unlock the worksheet first before locking any cells and then lock the worksheet again.
A little more information, such as your Excel version, operating system, and storage medium, would be helpful in finding a suitable solution.
Thank you for your patience and understanding.