hi,
I have formulas in cells of worksheets that I send my customers that I don't want them to see. Is there a way that I can protect cells so they can't see them?
hi,
I have formulas in cells of worksheets that I send my customers that I don't want them to see. Is there a way that I can protect cells so they can't see them?
When you right click on a cell, go to Format Cells, then choose the Protection tab. If you check "Hidden" and you protect the worksheet, cells labelled hidden will not show the formula.
G'day,
Hide the formula within a hidden column, with the protection sheet active.
Depending on your layout you may give a direct cell reference to the formula so that answer can be revealed on a unhidden cell.
Hope that helps.
Have I made you happy ??? If yes, please make me happy by pressing the Add Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Originally Posted by BigBas
WOW !!!!! The things you can learn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks