Excel activex control button

[Abhinav Shori]

Hello,
I created a button which copies values from another worksheet of the same workbook. I would like to select multiple worksheets and use this button but it does not work. Is there a way to make it work?

Thanks in advance

 

[Abhinav Shori]

thanks guys i used the form button and it worked

 

[Deepak]

Code pls.....