Forum Discussion
Lock Cells If Its not Updated Today
Hello all I have a scenario. Maybe you can help me. I have empty cells that need to enter date by my colleagues. I want below scenario If cell is empty its unlocked If a person enter a d...
Attached is the file with locked comments even if the cell value is subsequently deleted.
In order to remove the comments, the user needs to know the password to unlock the worksheet.
Give it a try, think this can work around your problem of deleting silent comments.
Password is "1234" can be changed arbitrarily in the VBA code.
The VBA project with password would then also be overlooked so that no one can see the VBA code.
Thank you for your understanding and patience
Hello NikolinoDE
I haven't seen any attached files. Am i wrong or you forget the add it?
Thanks a lot 🙂
I haven't seen any attached files. Am i wrong or you forget the add it?
Thanks a lot 🙂
Excuse me in advance, thought I had included the file for you.
Anyway attached the file, this time correct :).
As already mentioned, the user can now change the date as desired in the lines, but he cannot delete the comments in the respective lines.
Hope that helped :).