VBA to hide just one just 3 cells ?

[aedctalk]

Hi. Ok. I have a tracker for our job. However there is a part of the tracker that we only need 3 months of every year. called "stars of hope"

I'd like make it so that when a checkbox is checked YES (meaning show stars of hope)..

That these two cells will show up from being hidden.

I have the formula below i'm using to hide rows.. however i cannot hide rows for these. I need all the other cells in the rows and columns to show up.

Is there a way to hide just a cell? I'd be fine with making it invisible TO.. Is it posible to remove borders, background color, and change text color.. using vba?

anyway here is what i'im using for rows. Anyway to format the cell colors/borders or hide just the cell?

ActiveSheet.Unprotect
Dim cb As Excel.CheckBox

Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
Rows("107:108").EntireRow.Hidden = False
Else
Rows("107:108").EntireRow.Hidden = True
End If
ActiveSheet.Protect


say instead of hiding i just wanted to turn the cell completely white? is that easier? how to?

THANK YOU!!!

 

[Ruddles]

You can set its .Font.Color to vbWhite to hide it and vbBlack (or vbRed or whatever) to reshow it.