Calling a macro (on another sheet) using an image as a button

**excelaspire0219** · 02-05-2009, 10:15 AM

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.

**GuruWannaB** · 02-05-2009, 10:27 AM

Can you upload the file? You may need to modify the macro - to identify the activesheet you want the macro to function in. Depending on what the macro does that is...

**royUK** · 02-05-2009, 10:35 AM

Post your code, remember to use Code tags

**excelaspire0219** · 02-05-2009, 06:05 PM

Here is the code, it basically formats the sheet in a particular way - but I want to be able to call it from another sheet in the same workbook once the user pastes data into the macro workbook and clicks on the image (on the other sheet)

I think I will need some kind of a code to specify which sheet the macro should target - but I dont know that that is -

Can someone help??

Thanks.

Please Login or Register  to view this content.

**GuruWannaB** · 02-05-2009, 06:45 PM

You can always insert the macro command

Please Login or Register  to view this content.

before the code that does the formating. That way you format that sheet - regardless of which sheet the macro is called from. Afterwards tho...

Please Login or Register  to view this content.

to put yourself back at the starting point from where you called the macro.

Visually you will see a quick flip and the macro working...if you don't want that and just want it to work in the background - add:

Please Login or Register  to view this content.

at the start of the macro and

Please Login or Register  to view this content.

at the end.

Hope that helps,

GWB,

**royUK** · 02-06-2009, 04:04 AM

You don't usually need to select a sheet with code. How do you determine which sheet to run the code on? Your code currently runs on the active sheet.