Forum Discussion
Lock Cells If Its not Updated Today
Didn't forget you :)).
Attached are two examples with different approaches to the "almost" desired effect.
Both examples also have weak points depending on how you want to use the workbook.
Umarım örnekler size yardımcı olabilir :).
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Thank you so much.
The one "lock_with_data_entry" lock the cells after first entry. Cells can't change/update in same day.
The one "with_comment_stamp" working well. The only problem is, we need a backdoor or admin right/password for if someone do something wrong admin should change/update it with password. And column "K" (Duration(Planned)) is not locked.
Hovewer, You did really good job for me. I am so thankful to you.
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 :).
- Hello NikolinoDE
I haven't seen any attached files. Am i wrong or you forget the add it?
Thanks a lot 🙂 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