Hey guys.
I have a protected worksheet so that people in my office do not break some hidden formulas.
There are three columns on the sheet that we want to be able to hide or unhide, so that the sheet can be customer facing at times, and not customer racing at other times. (we dont want to show cost to the customer.... only sell price)
So unprotected, this is an easy fix... just group the three columns we want to hide (Columns Y:AA), and they can click the plus/minus sign.
Note: I ONLY want there to be control over columns Y:AA. There are other hidden columns that I do NOT want the user to be able to unhide.
But when the sheet is protected, they are not able to click those..... How can i get around this?
Bookmarks