I have just finished my excel application and I protect all of the sheets in my workbook.
The problem is every time I try to write on unprotected cells in a protected sheet and press enter/tab/ or simply move to other unprotected cells, I get the following error message:
The cells or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection using the Unprotect Sheet Command (Review tab, Changes Group).
You may be prompted for a password
I keep on getting around 2-3 such warning messages, and after that everything work normally i.e. the value of the cells change to the value that I have typed.
However, I found that this error is really annoying.
Is this a bug in excel application? or have I made a mistake?
Is there a way I can disable this error message?
Bookmarks