I want to hide the contents of a cell.
Not protect the cell, simply hide the contents.
Something like:-
Range("A1").Contents.Hidden=True
but of course that syntax doesn't work.
Help please
--
donwb

Assign a custom number format of ;;; (that's three semicolons). The value
will not be visible in the worksheet but will still be visible in the
formula bar. Without protecting the sheet, there is no way to prevent the
contents from appearing in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"donbowyer" wrote in message
...
I want to hide the contents of a cell.
Not protect the cell, simply hide the contents.
Something like:-
Range("A1").Contents.Hidden=True
but of course that syntax doesn't work.
Help please
--
donwb

Hi Chip
That did it fine. Many thanks
--
donwb


"Chip Pearson" wrote:

Assign a custom number format of ;;; (that's three semicolons). The value
will not be visible in the worksheet but will still be visible in the
formula bar. Without protecting the sheet, there is no way to prevent the
contents from appearing in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"donbowyer" wrote in message
...
I want to hide the contents of a cell.
Not protect the cell, simply hide the contents.
Something like:-
Range("A1").Contents.Hidden=True
but of course that syntax doesn't work.
Help please
--
donwb