Auto lock the Non-Blank Cells

[mvinay]

Hello Everyone

Can someone help me in providing the VBA code which automatically locks the Cells once the cell is filled with value.

Only those Non-Empty cells needs to get locked and Blanks should not be locked.

Thanks

[PaulM100]

This should do. It goes into the worksheet module

Please Login or Register  to view this content.

[mvinay]

Thanks Paul for your response.

Whereas this code is locking the Entire sheet.

I Need only the Cells that are non-empty needs to be locked and other Blanks should be available for entering values.