Macro code to protect cells after data entry

[mioakim]

I would like to protect the cells after data entry on the table.
there is already a vba code to show the date/time after entry on the table. Please advise

[rollis13]

Have a try with these lines of code I added to your macro. Now it will protect (no password entered) the cells once they have been filled. Before using it you should check that all cells in range A5:N43415 are formatted Unlocked.

Please Login or Register  to view this content.