Is it possible to protect 2 columns from the sheet which is in shared mode.

[Jagdev Singh]

Hi Experts
I am not sure if this is possible or not. If the excel file is in shared mode, the user can modify it. I want to know is it is possible to not allow the users to modify 2 columns from this sheet (Shared sheet). Only the restricted users should have access to modify these 2 columns.
Regards,
JD

 

[Asheesh]

Check if this helps...

http://support.microsoft.com/KB/289270

 

[Jagdev Singh]

Hi Asheesh

Thanks for the link. It help me to set the password protection condition on 2 columns first and then change the mode to shared later. I hope this works well for the requirement.

Regards,
JD