I am trying to find out if there is a way to automatically unlock a protected cell based on the contents of the cell.
I have a spreadsheet that is password protected. I am looking for a way to unlock a particular cell if the result of the formula in the cell is an error or a certain result. Is there a way to do this? I have a database of tools and the spreadsheet looks up the tool code and returns the description and price. Some tools are generic and some are specific. If the tool is generic I want to be able to change the description in the result table or if the tool is not found in the database I want to be able to change it too.
I have a spreadsheet that is password protected. I am looking for a way to unlock a particular cell if the result of the formula in the cell is an error or a certain result. Is there a way to do this? I have a database of tools and the spreadsheet looks up the tool code and returns the description and price. Some tools are generic and some are specific. If the tool is generic I want to be able to change the description in the result table or if the tool is not found in the database I want to be able to change it too.