Scenario...
I want to track the customers who walked in during a training.
5 key users will be using the shared workbook at the same time. Only one
column would be available for use. All others would be password protected.
The users will be able to select only "yes" from the drop down list.
Once selected and saved, no user should be able to delete this from the cell.

Please help.