K
Kevin B
Is there a way to only auto filter some ranges and ignor
others. This is the formula I'm using at the moment, it
will autofilter the columns C,D & E but I would also like
to add to filter the colum I2:I65536 an not to filter
column F,G and H. When I try to add the I range in the
formula all of the other ranges will display as AutoFilter
(ble).
Private Sub Workbook_Open()
'check for filter, turn on if none exists
With Worksheets("Time Entry")
If Not .AutoFilterMode Then
.Range("C2:F65536").AutoFilter
End If
.EnableAutoFilter = True
.Protect password:="", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub
Thank you for you responce!
Kevin
others. This is the formula I'm using at the moment, it
will autofilter the columns C,D & E but I would also like
to add to filter the colum I2:I65536 an not to filter
column F,G and H. When I try to add the I range in the
formula all of the other ranges will display as AutoFilter
(ble).
Private Sub Workbook_Open()
'check for filter, turn on if none exists
With Worksheets("Time Entry")
If Not .AutoFilterMode Then
.Range("C2:F65536").AutoFilter
End If
.EnableAutoFilter = True
.Protect password:="", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub
Thank you for you responce!
Kevin