Hello,
I would like to restrict users from resizing specific columns in my worksheet and allow them to resize or hide the others.
I've followed the steps to first unlock all cells by selecting the entire worksheet then format, unlocking in the Protection tab. Then I select the two columns I want to protect and lock those ones in the Protection tab.
However, when I protect the worksheet, it prevents resizing all of the unlocked columns as well, not just the ones that I locked.
I'm not sure where I've gone wrong. I see posts about locking and protecting specific cells but not this specific problem.
Thanks for any help!
I would like to restrict users from resizing specific columns in my worksheet and allow them to resize or hide the others.
I've followed the steps to first unlock all cells by selecting the entire worksheet then format, unlocking in the Protection tab. Then I select the two columns I want to protect and lock those ones in the Protection tab.
However, when I protect the worksheet, it prevents resizing all of the unlocked columns as well, not just the ones that I locked.
I'm not sure where I've gone wrong. I see posts about locking and protecting specific cells but not this specific problem.
Thanks for any help!