+ Reply to Thread
Results 1 to 3 of 3

Test needed if a selected table column has a filter button visible.

  1. #1
    Forum Contributor
    Join Date
    08-31-2021
    Location
    Kassel, Germany
    MS-Off Ver
    365 v2308
    Posts
    187

    Test needed if a selected table column has a filter button visible.

    Hi all, I have some code working to hide a filter button from a specific column of a table (in this example, it's column 5). The column doesn't require to be filtered, and the button obstructs the header. The code looks like:

    Please Login or Register  to view this content.
    What I'm looking for is the code I need to test if column 5 has already had the button removed. A search uncovered the following line of code, but it's not working for me. It only toggles between showing filter buttons for the whole table, or hiding them for the whole table.

    Please Login or Register  to view this content.
    All suggestions appreciated. TIA, Paul

    PS before you suggest I upload a file, this is a general question, it's not specific to any workbook.

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Test needed if a selected table column has a filter button visible.

    I am not sure how to check if a specific column has had the filter button hidden but the below code will let you know if they are all visible OR if one of the filter buttons is hidden:
    Please Login or Register  to view this content.
    If things don't change they stay the same

  3. #3
    Forum Contributor
    Join Date
    08-31-2021
    Location
    Kassel, Germany
    MS-Off Ver
    365 v2308
    Posts
    187

    Re: Test needed if a selected table column has a filter button visible.

    That works perfectly, thanks @CheeseSandwich.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter Visible Rows After Table Was Filtered
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2020, 12:27 AM
  2. filter source data based on visible data selected from a table
    By bluly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2019, 04:44 PM
  3. Selected pivot table filter items are not visible to VBA
    By dflak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2018, 01:24 PM
  4. Filter range and copy selected column visible data and paste other sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2017, 11:37 AM
  5. Table Filter/ Reset Button Needed
    By Rhall6310 in forum Excel General
    Replies: 3
    Last Post: 12-04-2014, 07:55 PM
  6. Table Filter/ Sory Reset Button Needed
    By Rhall6310 in forum Excel General
    Replies: 2
    Last Post: 12-04-2014, 02:28 PM
  7. [SOLVED] Code needed to test if user clicked a button
    By Subs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2005, 10:05 AM

Tags for this Thread

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