Unlock only specific ranges on a protected worksheet for specific users to edit

Copper Contributor

I am using a corporate notebook with Windows 10 and office 365.

 

As in title, i would like to protect a worksheet and give only to a specific user access to a certain range. 

I tried the procedure described here, but when I authorize user_A to edit range_A, it seems that all the users of the company have access to range_A. And if I authorize user_A to range_A and user_B to range_B, all users are capable to edit both range_A and range_B.

 

Is there a way to do this? 

 

Thanks in advance

0 Replies