Hi All

I have a excel file with active x option button and drop downs.
On clicking them they do something(hide some rows in large dataset below).

I have created a button in another excel file and wish to select these option buttons and then copy the result(filtered rows) in this file.

Can any1 provide VBA code.

Regards,
Vishal