I've found various threads on this, but not one that seems to work properly.
I have a workbook with multiple sheets that I need to lock the contents of except for the cells that are light blue. Colour code is 20, I believe.
Not sure if it makes a difference, but the cells either require data to be entered by the user or to choose an option from a dropdown box.
Additionally Id like to hide all formulas so they're not visible to the end user.
Much appreciate your help.
Cheers,
Matt
Bookmarks