Protect content of certain cells without protecting worksheet

We have a specific need and I am hoping someone can point me in the right direction. We have a excel 2016 workbook with multiple tabs. each tab is dedicated to a specific sales person. each salespeep, logins from a form, and his (only his) worksheet is unlocked and allow for editing. A table is present showing his past data. He is allowed to update or change most of his data in the table. He updates specific cells, saves and closes then workbook. the wb closing process, relocks his sheet. Before he leaves, he can look at other salespeeps sheets but cannot edit because they are locked. Now the rub. on each of the salespeeps sheets, certain columns (the same for all peeps) contain data entered by an admin. This data must be seen by the salespeeps but must not be altered. Any thoughts on how to protect certain columns from existing content change on an unprotected worksheet.

thanks in advance

Recent Questions...