HI, I'm hiding a column, but the checkboxes are still visible,
Here is the code
Sub FilterOH()
'
' Filters the OH Column
ActiveSheet.Unprotect ("unprotect")
ActiveSheet.Range("$A$9:$R$7084").AutoFilter Field:=19, Criteria1:="=TRUE", _
Operator:=xlAnd
' Hide the OH column
Columns("O:P").Select
Selection.EntireColumn.Hidden = True
Range("Q3").Select
'Protect the sheet
ActiveSheet.Protect Password:="protect"
End Sub
The problem is that each cell (o12:O778) has a checkbox linked to the adjacent cell in Column P
do I have to write a line of code to hide every single check box, or can I use some kind of range function for checkboxes?
thanks
Here is the code
Sub FilterOH()
'
' Filters the OH Column
ActiveSheet.Unprotect ("unprotect")
ActiveSheet.Range("$A$9:$R$7084").AutoFilter Field:=19, Criteria1:="=TRUE", _
Operator:=xlAnd
' Hide the OH column
Columns("O:P").Select
Selection.EntireColumn.Hidden = True
Range("Q3").Select
'Protect the sheet
ActiveSheet.Protect Password:="protect"
End Sub
The problem is that each cell (o12:O778) has a checkbox linked to the adjacent cell in Column P
do I have to write a line of code to hide every single check box, or can I use some kind of range function for checkboxes?
thanks