Macro activates in wrong sheet

I have a macro that fills a specific cell. When I click a button, the cell is filled. However, when I click the button, it opens another workbook and fills the cell in that one instead.

thanks,
Andrew

So what does the code for that button look like? What workbook/sheet do you want it to run on?

I figured it out. The other day I copied and pasted another sheet onto it, but I didn't paste as values, so it copied that sheet's buttons over it.