I need to make a checkbox allow a section of cells a10-c20 to be seen only if the checkbox is checked.
Sub CheckBox32_Click()
Sheets("Summary").Shapes("Button 2").Visible = Sheets("Summary").Visible = Sheets("Summary").Range("E3")
End Sub
This is the macro I use to display a new button if a checkbox is checked in another spreadsheet I have but I dont know how to display an group of cells. Do I simpaly make the text color White when its not checked and Black when it is? Or is there another way?
Thanks in advance.
Bookmarks