Forum Discussion
View to show which cells are locked/unlocked
Is there a way to easily view which cells are locked / unlocked without having to go into each one and checking its' format to see if the "Locked Cell" box is ticked? This would be really handy if y...
Haytham,
Thank you, I had thought of doing it this way and it will work for my application, however I was looking for a view that would not affect my print (although for my spreadsheet I have picked a very light fill colour).
Grateful for your support.
Cheers
To be able to view the locked cells using this method without affecting the normal formatting, I simply copied the entire sheet to a new tab and did the formatting to highlight the protected cells only in that tab.