Hi Guys,
I have a worksheet that is protected but I have left a couple of cells unlocked where I want users to enter data that gets fed into complex formulae. When I was protecting the worksheet I made sure to click the "allow users to select unlocked cells" option.
I have always been able to do this without any issues BUT since yesterday for all newly protected sheets I get the following pop up message when I click into a unlocked cell (even though I enabled the allow users to select unlocked cells).
Pop up box: "The cell or chart you're trying to change is in a protected sheet. To make change, unprotect sheet. You might be required to enter a password."
I am still able to enter a value into the data entry unlocked cells but only after I have okayed the above pop-up message. It is quite annoying to have the pop-up appear each time a data entry is made in an unlocked cell. Furthemore, I also get the pop-up message as soon as the protected sheet is opened.
I use Excel 2016 (that latest version). This never used to happen before.
How can I disable this pop-up box from appearing. Please help!! It will surely drive all my data entry staff bonkers too.
Thanks,
Yusuf
Bookmarks