Hi All,

Using the following code l can launch the Custom Auto Filter
(dialog???) and set the 'show rows whe' to 'begins with' The
downside is that is places a ? in the criteria box and the criteria box
takes the focus.

Can anybody help in modifying the code to avoid placing the ? in the
criteria box and it taking focus whilst still setting the 'show rows
whe' to 'begins with'

Application.ExecuteExcel4Macro "Filter?(1,""?*"")"

Additionally is there any risk attached to using Excel4Macro's in Excel
2000 to 2003 versions?

Regards

Michael beckinsale