ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Autofilter Button but keep the filter on (https://www.excelbanter.com/excel-programming/407271-hide-autofilter-button-but-keep-filter.html)

Vlad

Hide Autofilter Button but keep the filter on
 
I want to hide (make invisible) the autofilter button after i filter a data
but after hiding it to keep the filtered results and not to display all
records again. Any idea how can i do that?

Dave Peterson

Hide Autofilter Button but keep the filter on
 
Debra Dalgleish shares some code that can be used to hide those arrows.
http://contextures.com/xlautofilter03.html#Hide


vlad wrote:

I want to hide (make invisible) the autofilter button after i filter a data
but after hiding it to keep the filtered results and not to display all
records again. Any idea how can i do that?


--

Dave Peterson


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com