Control a Macro from Different Worksheet

[steveal]

I have downloaded a worksheet ('Data') which can access Yahoo for stock prices. The macro is controlled from a button on the worksheet "Download Prices". It works perfectly.
I use the data downloaded from Yahoo on another worksheet ('Mystocks') in the same workbook.

I want to run the macro using a new button on the 'Mystocks' sheet, so that I don't have to keep moving to the 'Data' sheet.
I have tried copying and pasting the button and tried creating a new button on 'Mystocks' without success. I've tried recording a macro to 'push' the button on the 'Data' sheet without success.

Can anyone suggest a solution?

 

[Norie]

Is there a macro assigned to the button on the sheet 'Data'?

 

[steveal]

Is there a macro assigned to the button on the sheet 'Data'?

There is,yes.

 

[Norie]

You should just be able to assign the same macro to any other buttons you create.

 

[steveal]

As I said, I tried to do that. It just wipes out ALL the data on the Mystocks sheet.

 

[Norie]

You didn't mention assigning the same macro the new button or wiping all the data from the 'Mystocks' sheet.

Can you post the code that's in the macro assigned to the button on the 'Data' sheet?

Also, where is that code located?

 

[steveal]

Norie,

I cross posted this on Excel Forum - made a bit of a mess of the thing, sorry. I don't want to complicate things more than I have.

 

[Norie]

No problem.

Mind you I think I can see what the problem is with the code after seeing it on the other forum - all the range/cell references in the code are to the active sheet.

Can you upload a workbook to the other forum?

 

[steveal]

Norie,

I've done that now with a great deal of help!