Forum Discussion
Re: Lock Cells If Its not Updated Today
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
2 Replies
- Hello NikolinoDE
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 :).
