Hiding Formulas
One aspect of Excel’s protection is the ability to hide the contents of a cell. The cell still displays, but the formula bar remains empty when the cell is selected. This is useful if you don’t want the users to see the formula for the cell.
On the Protection tab of Format>Cells, check the Hidden box.
Then protect the sheet using Tools>Protection>Protect Sheet. With the Hidden property checked and the sheet protected, the formula is no longer visible to the user.
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Leave a comment