Hide cell contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

donbowyer - 27 Nov 2007 23:38 GMT

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

Signature

donwb

Reply to this Message

Chip Pearson - 27 Nov 2007 23:54 GMT

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.

Signature

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

>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

Reply to this Message

donbowyer - 28 Nov 2007 12:54 GMT

Hi Chip
That did it fine. Many thanks

Signature

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
[quoted text clipped - 7 lines]
> > but of course that syntax doesn't work.
> > Help please

Reply to this Message