VBA : Lock column after data entry

Try the attached file. I'm using the file in your original post. Enter the data, colum D last and exit the cell. If you click 'Unprotect Sheet" you will be asked for a password (passme).