Hiding the content of a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I searched this ng and found that hiding a cell can be done using various steps of worksheet protection and password access using a macro but found no steps nor macro description.

I have 2 cells (W6 and X6) on a worksheet that need to be completed in order for the file to pass to the next step in the process, but the end recipient should not be able to see this date (cell X6).

Can someone walk me through how this can be done?
Thanks in advance...I hope!
 
Marcy,

You really can't hide a particular cell.
You can hide the entire row or column that the cell is on.

One other option would be to format the font color as white.
They'll still be able to see the value if they select the cell and
look at the formula bar, but for all practical purposes, it'll
be invisible on the worksheet.

Another option.....
Position a textbox over the cell to hide the contents.

John

Marcy said:
I searched this ng and found that hiding a cell can be done using various
Click to expand...
steps of worksheet protection and password access using a macro but found no
steps nor macro description.
I have 2 cells (W6 and X6) on a worksheet that need to be completed in
Click to expand...
order for the file to pass to the next step in the process, but the end
recipient should not be able to see this date (cell X6).
 
Back
Top