• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Button to turn on an off diferent filters

S

sveinhelge.urdal

Member
Is it possible to make a button with a macro ore something that turns on a filter? I have some filters that I would like to assign to a button. And allso a button that turns off all the filters.

Can anyone guide me in that?
 
Link to related post:

http://chandoo.org/forums/topic/changing-range-in-dynamic-filter#post-92289


It's certainly possible. I'd suggest recording a macro of you setting up the filters, and then assign those macros to command buttons.


Also, several handy short macros for dealing with AutoFilter, including show all data:

http://www.contextures.com/xlautofilter03.html
 
You must log in or register to reply here.
Back
Top