Command Button Code

I've written a little macro that open a workbook, copies the data and pastes it into this workbook.
To work the macro, I added a command button and copied the code I wrote into the sub for the command button. Now it doesn't work. It does strange things.......so firstly, does the VBA in a command button work in a different way, and how can I get around it?

My code is as follows (Sheet "Menu" has the command button, and Sheet1 is the sheet I want to copy the data into)

Please Login or Register  to view this content.

Any advice gratefully received. Tks Caroline

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You need to specify which workbook and/or sheet you are deleting from. Something like this

Please Login or Register  to view this content.

You don't need to select or activate workbooks & ranges, so your other code could be improved

You are using the sheets code name rather than it's tab name.

Please Login or Register  to view this content.

The above code uses code name and then tab name to display sheets name.

If you look at the Project window in the VBE you will see the code/tab name of the sheets in your workbook. You should see Sheet1 has the name (Menu)

We need to see your latest code. Even better would be an example workbook

The button is on the menu sheet, because you don't specify the code to run a different sheet it clears that sheet