Automatically locking cells after manual entry on or before a particular day

Originally Posted by mdethira

I have created a DASH board for my team in which i want my team members to update their comments onit, where the cells should get locked immediatly after the manual entry or it get locked once the user has failed to update on or before a particular day.

Please help.

Anyone please help, provide me a macro for the above request.

I'm not an expert but you could set the protection on the comments cell to unlocked. Then protect the sheet so only unlocked cells can be selected.

Then have a userform (UserForm1) with a text box and 2 command buttons. Set the ControlSource property of the textbox to the reference of the comments cell. In the code below, B5 is the comments cell.

Then the two command buttons can be one for "Enter" and one for "Cancel"

The "Enter" Command Button Could then have the code:

Please Login or Register  to view this content.

The Cancel Button Could Have

Please Login or Register  to view this content.

As for the date issue. Then you could create a workbook_open event to check if a deadline has passed and protect the comments cell if it has....

Please Login or Register  to view this content.

Then simply put a button next to the comments box (B5) and assign a macro with a single line of vba

Please Login or Register  to view this content.