Auto Filter - Custom Auto Filter

[Johnnyboy5]

The issue I've encountered is that the macro recorder can't be stopped
with the Custom Autofilter Dialog Box open. Is it possible to create a
macro to goto select Custom from the drop down list, and the dialog
box that then appears ?

I must finish the sheet this weekend and cant trust the end users to
use the list without a marco !

many thanks

 

[p45cal]

in xl 2003:
Application.Dialogs(xlDialogFilterAdvanced).Show

or with parameters (search help for "Built-In Dialog Box Argument Lists" and
the parameters for this one are:
operation, list_ref, criteria_ref, copy_ref, unique)
You can get a clue for what form these can take from looking at the vba help
for the AdvancedFilter Method

Application.Dialogs(xlDialogFilterAdvanced).Show xlFilterCopy,
Range("D6:N16"), , Range( "D22"), True

 

[Johnnyboy5]

in xl 2003:
Application.Dialogs(xlDialogFilterAdvanced).Show

or with parameters (search help for "Built-In Dialog Box Argument Lists" and
the parameters for this one are:
operation, list_ref, criteria_ref, copy_ref, unique)
You can get a clue for what form these can take from looking at the vba help
for the AdvancedFilter Method

Application.Dialogs(xlDialogFilterAdvanced).Show xlFilterCopy,
Range("D6:N16"), , Range( "D22"), True

Thanks, nearly there, but the macro opens "advanced" and I just
need it to open the (Customer...) option Custom Auto filter.

Can you still help me here...

thanks very much for replying in the first place

Johnnyboy

 

[p45cal]

Aha.. well there doesn't seem to be one, hmmph
Perhaps there's anotherway to do the equivalent.. what are you trying to do;
what might the user be entering into the custom autofilter dialogue?

 

[Johnnyboy5]

Aha..  well there doesn't seem to be one,  hmmph
Perhaps there's anotherway to do the equivalent.. what are you trying to do;
what might the user be entering into the custom autofilter dialogue?

Hi

they would be looking for a record number in column A and then just
be able to edit that row without seeing all the other rows (they could
miss a line) also I have put a button on it called ALL so they can
restore the full list at the end of editing the row they needed up
date.

Its for a reablement team and its reocrds of referrals, work done etc.

many thanks for your consideration.

Johnnyboy