How to disable AutoFilter

[tuongtu3]

Hello All,
I have a sample in attached and please help me to disable all AutoFilter by code.

Regards,
tt3

[Johfra]

What version of Excel do you have?

If 2010:
choose DATA - then choose FILTER

You need to be in the first cell that you want the filter removed from. You need to do this for each row. In your case, B2, B6, etc.

[tuongtu3]

@Johfra:
Thank for your help. I'm using Excel2007 and I would like marco to automate.

Regards,
tt3

[Johfra]

Oh, you want this to be done through macro?
What I've done for other spreadsheets is I created a button with "Filter On" and "Filter Off". Much easier for the user.
Do you know how to create macros? (just to know how to help you better)

[tuongtu3]

Hi Johfra,
Can you create a macro to "Filter Off" per my sample attached in post# 1?
Thank you for your help.

Regards,
tt3

[Alf]

As far as I can see your sheet contains a number of tables!

You got "Table1" to "Table4" + a "Table6". In order to get rid of these "table formats" one really should know the number of tables. Still I'v written a macro that checks up to 10 tables and you can increase this if needed be.

Please Login or Register  to view this content.

Alf

[tuongtu3]

Hi Alf,
The code work with sample in attached but it did not work with the real ws. Please take a look and see if there's anything you can help
(This is a real ws but I deleted all data).

Regards,
tt3

[nilem]

maybe

Please Login or Register  to view this content.

[Alf]

You latest uploded file has tables 22, tables 36, tables 38 and tables 44 so if you wish to use my macro change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

But have you tried nilem's code? Looks better than mine since he don't use a hard coded integre.

Alf

[tuongtu3]

@Nilem & Alf: Both codes work perfect. Thank yu very much for your time and help.

One question:

You latest uploaded file has tables 22, tables 36, tables 38 and tables 44 so if you wish to use my macro change

How to check the table number#???

Regards,
tt3

[nilem]

something like

Please Login or Register  to view this content.

[tuongtu3]

Thank you all for your time and help.

Regards,
tt3