Results 1 to 5 of 5

Thread: Filters (XP)

  1. #1
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Filters (XP)

    I'm not familiar with this feature, and when I search for AutoFilter in Word's help file, I get references to filtering HTML and email discussions. ???

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Filters (XP)

    Chona

    Is this for Word or Excel? The status bar in Excel shows something like this but mine says 1 of 6 found. I don't know how to get the status bar to always show this but it will come back anytime I click on any one of the autofilters to reapply that filter setting.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filters (XP)

    I noticed that sometimes when I use autofilter and select a item to filter by, that in the bottom left hand corner it would say 1 of 6 filtered. How do I get this to always turn on? Or stay on!

    Sorry I must have been asleep when posting - this question is suppose to be in Excel. Sorry Sorry

  4. #4
    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

    Re: Filters (XP)

    See if some of the workarounds mentioned by Microsoft help.

    Steve

  5. #5
    New Lounger
    Join Date
    Jul 2002
    Location
    Auckland, New Zealand
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filters (XP)

    You may have inadvertenly turned it off by clearing the status bar area ....
    You can try turning it back on via code.

    Application.StatusBar = False

Posting Permissions

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