Oct 21 2019 06:00 AM - edited Oct 25 2019 06:52 AM
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 that time.
The workbook consists of several sheets and this error does not occur there.
Does anyone know what to do?
Thanks!
Ciska
Oct 22 2019 02:21 AM
Oct 22 2019 02:36 AM
Hi, thanks for your reply. It is specifically about cells with formulas in the last tab 'monitoring projecten', like A5:A24. These cells are locked and even if the sheet is protected, the content can be deleted.. The same applies for example J5:T24, Q37:T37, Q39:T41 and so on..
Maybe I forgot to protect this sheet before uploading, but if you try you'll see.
Oct 22 2019 02:52 AM
Oct 22 2019 02:58 AM
yep, indeed... and given the amount of referrals, I hope there's another solution before I have to replace it completely
Oct 22 2019 04:35 AM
SolutionOct 22 2019 07:20 AM
Yes, thanks! this was the cause, problem solved! I wasn't aware of this..
Oct 22 2019 04:35 AM
Solution