Results 1 to 3 of 3

Thread: Table Headers

  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Location
    Bruges, Belgium
    Posts
    122
    Thanks
    14
    Thanked 2 Times in 2 Posts

    Table Headers

    TestTable.png

    Attached image shows a table that contains a column with sparklines. As I have no need to sort the sparklines (nor the data columns D to G, for that matter) I want to remove the inverted triangle from that header. Can it be done?

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi rvWoody

    You can hide specified dropdown filter arrows using VBA as follows:

    Code:
    sub hideMyFilter()
    
    [a1].currentregion.AutoFilter Field:=3, VisibleDropDown:=False    '3=column [C] = third filter in data block
    
    end sub
    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    rvWoody (2014-05-18)

  4. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out MS MVP Debra Dalgleish blog at http://blog.contextures.com/archives...el-autofilter/. She describes how to hide the autofilter arrows. It can be done manually or with VBA code.

    Steve

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    rvWoody (2014-05-18)

Posting Permissions

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