View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sjoo.kwak@gmail.com is offline
external usenet poster
 
Posts: 18
Default Need help hiding/unhiding column based on autofilter selection in a different column

If you change your selection of a item from "autofilter list",
Worksheet_Calculate event is triggered,
therefore you can write macro you want using this event procedure.

for example,

Private Sub Worksheet_Calculate()
Dim w As Worksheet, f As Long

Set w = sheet2

With w.AutoFilter
With .Filters
For f = 1 To .Count
With .item(f)
If .On Then

'// When Jan.15,93 is selected, you want to hide some columns
If .Criteria1 Like "*01-15-93" Then

'// Codes Hiding some columns are here
Debug.Print "Hide Columns"
Exit Sub

End If
End If
End With
Next
End With
End With
End Sub