Hiding & Unhiding Cells, How to
 

Dennis,
To hide a cell ~ go to format cell and choose CUSTOM under the number tab -
then type in ;;;
That's it!

Diane


"Dennis" wrote:

XL 2003 & 97

This should be easy but ....

Attempted to hide certain cells by alternately clicking or unclicking
(Locked / Hidden) boxes on the respective Cells' Protection Tab - then
locking the worksheet.

My luck ...!? the cells are still visable! What obvious step am I missing?

**********************************
The real goal is that I want (via VBA) to unhide all hidden cells in all
worksheets in a workbook. I have the code to unhide Rows and Columns. (What
about individual cells? Should that be a separate step? I think so.)

In addition, I would like to find, and reset, all cells where the font color
and cell fill color are the same - effectively hiding the contents of the
cell from viewing and printing.

Any help is appreciated.


TIA Dennis