Hide cell contents

  • Thread starter Thread starter donbowyer
  • Start date Start date
D

donbowyer

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
 
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)
 
Hi Chip
That did it fine. Many thanks
--
donwb


Chip Pearson said:
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)
Click to expand...
 
Back
Top