Let me know if you need me to upload a file to see for yourself what I'll describe below.
I have an Excel file with many of the cells locked and the sheet is password protected. For example, I have a column of unlocked cells that users can enter numbers into. At the bottom of the column is a simple SUM formula that adds up the cells above it. The cell that the SUM formula is in is locked. The data in that cell will change based upon changes users make to the numbers in the cells above...as it should. No problem.
I have another cell that, based upon what value a user selects from a combobox on the sheet, will display a message if a certain value is selected. I locked the cell that the message displays in because it has a formula in it (the formula is what causes the message to display under certain conditions) that I don't want users to be able to change.
When I protect the sheet and make a selection from the combobox that SHOULD display the message per my formula, I get the following error: "The cell or chart you're trying to change is on a protected sheet."
Any way to correct this? It seems the use of a combo box is what's causing the problem since protected cells with math formulas such as the one I described initially above allow changes no problem.