+ Reply to Thread
Results 1 to 2 of 2

Need help hiding/unhiding column based on autofilter selection in a different column

  1. #1
    kcleere
    Guest

    Need help hiding/unhiding column based on autofilter selection in a different column


    I have a task before me I need help with.

    I have a customer (My Boss) who wants to hide 2 columns in a
    spreadsheet automatically when a specific text is selected from an
    "autofilter list" in a different column. Then, show the hidden column
    again when any other text is selected in the filter list column.

    It's not obvious to me how to do this or if it can be done in Excel.
    I'd appreciate any input you have here.

    Thank you in advance for any input you have.


  2. #2
    sjoo.kwak@gmail.com
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1