• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Locking the Columns with different passwords

C

chssundeep

Member
Hi Excel lovers,

I need your help..I have an excel where it will be accessed and filled by 10 users...

I want to lock Column wise with a password to each user

The Column A will be updated by User 1 and he should have access to only Column A

Similarly

The Column B will be updated by User 2 and he should have access to only Column B

Attached the excel sheet for reference
 

Attachments

Under the Review ribbon, you can select "Allow users to edit ranges"
upload_2014-9-8_13-51-8.png

In the dialogue, you can specify what range, and assign a password to each range. (If you want to get even fancier and are on a network, you can specify which people can even have a chance to enter password. )Then, protect the worksheet (button in bottom left). Now if you try to edit one of the ranges, you must supply that range's password.
 
You must log in or register to reply here.
Back
Top