Hiding cell values in Excel 2000

[Stuart]

Without hiding a row or column, and without protecting a cell,
I can do the following::

i select a cell
ii right click and choose Format Cells
iii select Custom
iv in the Number tab, select Custom from the Category list
v in the Type box, enter ';;;'

On screen, the cell appears to have no value. However, if the user were
to select it, then the formula bar would show the value.

Could I develop this for programmatic use, such that:
a: the user can still select the cell
b: the formula bar remains empty
c: user cannot make changes to the cell's value

Regards

 

[Ron de Bruin]

Hi Stuart

ii right click and choose Format Cells

On the Protection Tab check Hidden also before you
protect your sheet

 

[Ron de Bruin]

This is the code

Selection.NumberFormat = ";;;"
Selection.Locked = True
Selection.FormulaHidden = True

And protect your sheet then

 

[Stuart]

Many thanks.

Regards.

This is the code

Selection.NumberFormat = ";;;"
Selection.Locked = True
Selection.FormulaHidden = True

And protect your sheet then