Protect the Workbook & share

[sur]

Hello All,

I have a workbook, which is placed in a shared drive, as i now need to update the work allocation & for each team member in different sheets under there name.

Help required;

1. Need to protect the columns in all the sheets of the team member & allow few columns AB to AZ to allow editing.
2. And share the workbook - the protected sheet should work.

Is there any way to do it.

Thanks,
SUrendar.