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 a
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


--
p45cal


"Johnnyboy5" wrote:

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