Excel hide cell contents 1

[vandaliarental]

Is there a way to hide the contents of a cell depending on a check box?

I have a spreadsheet showing a 'Total:' & a sum of the above cells. If the user unchecks the total check box, I'd like to hide the word Total & the sum amount. There may be other information in the row, so I can't hide the entire row.

Thanks in advance!
Connie

 

[barcon]

Could you make it seem invisible by changing the font to the background color, white for instance?

Set rng = ActiveSheet.Range("a3, b3")
rng.Font.Color = RGB(255, 255, 255)

Barbara

 

[vandaliarental]

That'll work!! Have a star!

 

[SkipVought]

FYI...

rng.Font.Color = vbWhite

Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie![/sub]

 

[vandaliarental]

Thanks, Skip! That's much easier to read!

 

[rmikesmith]

Or perhaps for maximum flexibility:

With rng
  .Font.Color = .Interior.Color
End With

Regards,
Mike

 

[vandaliarental]

So many ideas...so little time!!

Thanks for all of them!

Connie