How to add a button in excel 2007

[djkahc]

Hi every one,

I have two workbooks one is the source which has a large data and the other is the destionation, I even have the code which transfers the data from the source to destination, (I open the two files press Alt+F11, paste the code and when I click 'run' in the VBA editor the data gets transfered.)

Is there any way I can create a button in my destination workbook so that with the click of the button i can run the code?

Thanks
Ram

[jaslake]

In Excel 2007, click on the Developer Tab, click on Insert, click on Button(form control). Draw the button on the worksheet. Right click on the edge of the Button and assign your existing macro to the button. Click outside of the button (to deselect). Click on the button and it will run your macro.

Hope this helps.

J