Inserting a Graphic on a Button when the Button is Assigned to a M

S

smck

I am working in Office Excel 2007. Inserting a Text Box from Developer Tab,
Controls Section, Insert, allows you to insert a Text (Form Control) button
to which you can assign a macro.

I would like to have a graphic image instead of text on that button but am
not able to. I have tried to Insert (ActiveX Control) from that same section
but it does not allow me to assign a macro.

My question is, can this be done? If so, does anyone know how? Please help.

Thanks
 
B

BSc Chem Eng Rick

You don't need to use a control for this. Just insert your image as per usual
Insert --> Picture --> from file...

Now right click the image and "Assign Macro"

If this helps, please click "Yes"
<><><><><><><><><><><>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Cannot insert object' message when I try to put a button on a worksheet 7
Macro Button Question 4
How to identify macro assigned to toolbar button 3
Macro Assigned to a Button 1
How to see which Marco is assgined to a form control button 2
Button Confusion 2
How can I assign a macro to a graphic object on the worksheet 1
Assign Function to a Command Button 1

Top