hi boni,nick

thanks for the help.. but i have a bit different problem..
when the user selects two items from the list of the dropdownlist box say
(item1 and item4) and selects the colums with all the for those two
selections and press ctrl+c and opens a new work sheet and presses ctrl+v..
i want only those rows to be copied which matches the autofilter criteria....

one way is to do it with f5-special-visible cells only then ctrl+c and
then ctrl+v.. but i want that to be done in VBA code....

waiting 4 u replies..

and one more thing .. is there any way we can restrict the user from copying
anything from the excel.. i.e to disable ctrl+c option...
"Pramod Mehta" wrote:

hi all,
as in excel 2003 while using auto filter in a particular column we get the
drop down list box and the user has the choice of selecting and one from teh
whole list, but in excel 2007 while using auto filter option we get the drop
down list box with a checkbox prior to it allowing the user to select
multiple rows in the filter.

can the auto filter in teh excel 2007 can be modiifed to display teh data as
in the form of excel 2003 (ie without the check boxes in front of the list)