+ Reply to Thread
Results 1 to 7 of 7

Not showing the arrows from filter

  1. #1
    Forum Contributor
    Join Date
    11-20-2014
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    177

    Not showing the arrows from filter

    Please Login or Register  to view this content.


    This is something I stole from googling to make the arrows on my filters invisible.
    I tried it for Cell A3 as you can see and it works for worksheet 1 and 3 but not for the others... Does not makes sense to me.

    Help is appreciated
    Last edited by Gaellus; 04-25-2016 at 03:35 AM.

  2. #2
    Forum Contributor
    Join Date
    11-20-2014
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    177

    Re: Not showing the arrows from filter

    Help is still needed and very much appreciated.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Not showing the arrows from filter

    Do you have Tables on the other sheets? Can you post a sample sheet that doesn't work?

  4. #4
    Forum Contributor
    Join Date
    11-20-2014
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    177

    Re: Not showing the arrows from filter

    Attached a bit I copied out of my workbook. As you can see it makes the Arrow in cell A3 in worksheet 1 invisible but not in worksheet 2.
    Has it anything to do with the fact that worksheet 2 has less columns than 1 so the range in the code is wrong?
    Attached Files Attached Files

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Not showing the arrows from filter

    Your code only runs on whichever sheet is active - did you activate sheet2 first? You can deal with the different ranges using:
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    11-20-2014
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    177

    Re: Not showing the arrows from filter

    How do you mean "activate"? I made it with the additional code so it activates when opening the workbook:

    Please Login or Register  to view this content.

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Not showing the arrows from filter

    Your code only runs on one sheet - whichever one has been selected. It doesn't loop through all the sheets in the workbook.

+ 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] how to add the values of the arrows showing positional change
    By kenechukwu in forum Excel General
    Replies: 19
    Last Post: 11-19-2015, 09:28 PM
  2. Showing progress with arrows
    By bogdn in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 04:31 AM
  3. Showing up/down arrows in cells
    By shades99 in forum Excel General
    Replies: 2
    Last Post: 03-15-2010, 10:49 AM
  4. Filter arrows freezing!
    By Stilla in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-15-2006, 10:25 AM
  5. [SOLVED] color of filter arrows
    By Tanguy Huysmans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2006, 06:15 PM
  6. [SOLVED] filter arrows showing when copy and paste to powerpoint
    By confused in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-11-2005, 08:30 AM
  7. Replies: 4
    Last Post: 09-27-2005, 10:05 AM

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