I have a workbook with two worksheets. I have a macro on one of the worksheets which I want to call using a image as button which resides on the second sheet. When I wrote the macro there was just one sheet, I later added another sheet and put the image on it and assigned the macro to the image. However, when I click the image the macro runs on the sheet which contains the image. How can I make the macro run on the sheet that I want it to run??
Thanks.