Data Entry Protection

[Reno_1974]

I am having an issue with a shared workbook spreadsheet. One of my employees had entered in some data, however after he left work his data had been changed. Is there any way I can protect general data entered in a worksheet so that once entered it cannot be changed?

 

[HippoCampus]

Hi Reno

The only way I can think of is that you create a userform to input the data to the WB and then you can add code to first unlock, run the macro, lock. You can then password protect the VBA to stop anybody changing it.