How After Filtering Hide Arrows Filter Vba

Gurley Geoppince · 08-20-2016,05:17 PM

08-20-2016,05:17 PM #1

torch0395 is offline

Registered User

Hiding table filter arrows

Is there a fashion to hide the arrows except for one of the columns. I know if I take information technology off filter information technology will hibernate all the arrows but I just need one of the columns to exist able to filter the information. Thanks for any assist

08-20-2016,07:26 PM #2

Re: Hiding table filter arrows

08-20-2016,08:06 PM #3

Re: Hiding tabular array filter arrows

Your mail service title does not friction match with the description. Anyway, I am providing you the possible solutions without VBA.
If you are trying to set filter in i column only, but this is not the 1st cavalcade then,

ane. The easiest manner to do that is creating a table. Select the column, then become to Insert tab and click on Table and and then ok. That's information technology. You can hide the pointer also. Just select the table and uncheck the Filter Button on Blueprint tab.

2. Another fashion is almost manual filtering. Click on the column header, and then go to Information tab. Then click on Advanced. At present check "Unique Records But" if you wan to filter the unique records only. So ok. Or, if y'all want to filter with a specific criteria and so write downwards the criteria range. But this is the worst fashion I think as it is all manual.

If you want to hibernate the filter arrows from all columns except one and so, you demand VBA.

Terminal edited past sanram; 08-20-2016 at 08:09 PM.

08-20-2016,08:13 PM #4

torch0395 is offline

Registered User

Re: Hiding table filter arrows

eleven-29-2018,01:34 PM #5

Obfuscated is offline

Registered User

Re: Hiding table filter arrows

I know this is an old mail service, just someone may be able to use this bit of code.
(Uses VBA) This will put filter dropdown arrows from "A3:H3" for those people who have multiple header rows.
It volition then remove the dropdown arrow from the 4th & 7th columns (D & Chiliad) so that the only columns that are filtered are A-C and Due east-F and H.

Hope this clears upward some questions about unique filters.

11-29-2018,02:09 PM #half dozen

Re: Hiding table filter arrows

Originally Posted past Obfuscated

I know this is an erstwhile post, but someone may be able to employ this scrap of lawmaking.
(Uses VBA)

This will put filter dropdown arrows from "A3:H3" for those people who have multiple header rows.

It will then remove the dropdown arrow from the 4th & 7th columns (D & Chiliad) and then that the only columns that are filtered are A-C and Due east-F and H.

Hope this clears up some questions well-nigh unique filters.

This was answered in post #2