M
michael.beckinsale
Hi All,
Using the following code l can launch the Custom Auto Filter
(dialog???) and set the 'show rows where:' 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
where:' 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
Using the following code l can launch the Custom Auto Filter
(dialog???) and set the 'show rows where:' 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
where:' 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