How to reapply an advanced filter automatically

[busyman5_au]

I have used a filter and list formatting to create the worksheet the wa
I want it and the data refreshes (from external links) when I open th
workbook.

But the advanced filter has not been applied.. it works if I click o
it in the menu bar.

How can I re-apply this filter automatically when The data is refreshe
?

Thank

 

[Paul Falla]

I would try recording a macro that firstly performs the
data refresh, and then the filter.

Hope this helps

Paul Falla

 

[busyman5_au]

Almost there now... data refresh is done and a macro (on a butto
control) works for reapplying the filter.

BUT

my macro doesn't handle the situation when the user types in a ne
value into the criteria cell and DOESN'T move off of it. They ca
click the "reapply filter" button I created but the new filter valu
hasn't been fully "input" yet.

How can I force in my macro the ending of any input ?
or force a <TAB> or <ENTER> ?

Here is the current macro....

==============================

Sub mh_apply_filter()
'
' mh_apply_filter Macro
' To allow refresh of the filtering. Macro recorded 27/02/2004 b
administrator
'

'
Range("F10").Select
Range("A10:AB210").AdvancedFilter Action:=xlFilterInPlace
CriteriaRange:= _
Range("C7:C8"), Unique:=False
End Su