Hidden cells
 

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

Hidden cells
 

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.
--
Gary''s Student - gsnu201001


"HuaMin" wrote:

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

Hidden cells
 

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

"HuaMin" wrote:

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