Hidden cells

[HuaMin]

Hi,

In the Excel sheet, I've clicked 'Hidden' in 'protection' tab in 'Format
cells' of the cell, and then I protected the sheet. But the 'hidden' cells
that I expect to have are still visible!

Bst Rgds,
HuaMin

 

[Gary''s Student]

When a cell is hidden, only its display in the formula bar is hidden. To
hide the cell display, set the font color to the same as the cell background
color.

 

[מיכ×ל (מיקי) ×בידן]

If I understood your question - there is now way to hide single cells - you
need to hide complete row(s) and/or column(s).
The way you acted - you have hidden the cell(s) formula(s) in the Formula
Bar and the formula will remain hidden even upon pressing: CTRL+~
If you need to hide the cell(s) content (value) you can use custom-format:
;;; and/or use white font.
The best and secured way is to use an adjacent sheet to reflect all the main
sheet cells and to define the main sheet as xlSheetVeryHidden in the VB
editor to which you can access with ALT+[F11].
Now, all that remains is to password protect the VBProject.
REMEMBER:
A Worksheet Protection Password can be, easily, cracked within 30-45 seconds !
Micky

 

[YESHWANT]

hi HuaMin,

for protecting a particular cell, row or column in true sense requires that
these cells besides being hidden, should be locked.

so, if u want to cell to be locked & formula to be invisible, kindly select
"locked" & "hidden" in 'protection' tab in 'Format cells' of the cell.

think over it and you will be at home

learn - n - enjoy

 

[AdamV]

"Hidden" means that the cell's contents are not shown in the formula
bar, so if your cell contains a formula only the result is seen by the
user, not the logic of how that result was achieved.

To hide cells without hiding rows and columns you can suppress parts (or
all) of the cell number formatting.

A custom format of ;;;; will show absolutely nothing in the cell, only
in the formula bar. If you then protect the sheet and these cells are
marked as "hidden" you will not be able to see their contents on the
sheet or the bar (but can still access them wth formulas from other
cells, even ones a new sheet which by definition you can't protect).

The only way to make them totally inaccessible to the user would be
hiding the rows or columns before protecting the sheet, or hiding the
whole sheet and protecting the workbook.

Hope this makes it clearer for you
Adam