Forum Discussion
Solved
content protected cells can be deleted even though cell is blocked and worksheet is protected
Hi, In one of the worksheet it is possible to delete content of protected cells even though cells are blocked and the worksheet is protected. The workbook contains macros, but they are not active at...
- I've found a possible cause for this. It looks like the fact that you have set up "Allow Edit ranges" interferes with the worksheet protection and locked cells.
yep, indeed... and given the amount of referrals, I hope there's another solution before I have to replace it completely
I've found a possible cause for this. It looks like the fact that you have set up "Allow Edit ranges" interferes with the worksheet protection and locked cells.
Yes, thanks! this was the cause, problem solved! I wasn't aware of this..