Assumed Col A is used and rest of columns need to protect.

Ctrl + A | Ctrl +1 | protection tab | uncheck locked and hidden | ok

Select all the columns except Col A , Ctrl + 1 | protection tab |
check locked | ok

Now go tools | protection | protect sheet | ok

to share the workbook | tools | share workbook | ok



On Feb 11, 12:45*pm, Fuzzy wrote:
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.