Hide columns using check boxes

jumpcut 

In that case, you should first locate a column with header "Notes" on Sheet1 and if it is found, you hide or unhide it irrespective of which column contains that header.

Please try it like this and don't forget to tweak the Sheet Names in the code...

Dim ws1         As Worksheet
Dim ws2         As Worksheet
Dim headerCell  As Range

Set ws1 = Worksheets("Sheet1")
Set ws2 = Worksheets("Sheet2")

'Assuming headers are in Row1 on Sheet1
Set headerCell = ws1.Rows(1).Find(what:="Notes", lookat:=xlWhole)

If Not headerCell Is Nothing Then
    headerCell.EntireColumn.Hidden = Not ws2.Range("A8")
Else
    MsgBox "The column with header 'Notes' was not found.", vbExclamation
    Exit Sub
End If