In general, is there a way to automatically lock individual cells once data has been entered, protected by password? Will such a process also lock cells that are populated by selecting from a drop down list?

This would need to be effective on a shared workbook.

Thanks!