protect cell content after save

[ENEMALI]

How can I protect the information of a cell after the user writes in the cell?

I would like to protect the information after the user saves and closes the workbook and prevent the user from changing the information after saving and when opening the workbook the second time except with a password.
if this is possible with macro, any assistance will be appreciated

[Paul]

Hi Enemali,

Add this code to the 'ThisWorkbook' code module in the VB Editor (ALT+F11):

Please Login or Register  to view this content.

Substitute "your-password-here" with a password of your choice. This code will run when the user saves the workbook and will password protect every worksheet with the same password.

You can then prevent them from viewing the code (including your password) by protecting the VB Module. In the VB Editor click Tools > VBA Project Properties > Protection tab. Select "Lock project for viewing" and enter a password only you know. Don't forget it, or you won't have access to the code either.

Excel is not a secure environment, so the determined user can break in, but this will keep most users out.

[ENEMALI]

thanks Paul
it works perfectly
keep on your good work

[ENEMALI]

a little assistance please
the macro above work as i wanted initially but now i want it to lock only cells containing datas leaving empty cells for data input but when filled, it locks it when saved
thanks in advance