If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting a Graphic on a Button when the Button is Assigned to a M
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 |
#2
|
|||
|
|||
Inserting a Graphic on a Button when the Button is Assigned to a M
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" "smck" wrote: 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 |
#3
|
|||
|
|||
Inserting a Graphic on a Button when the Button is Assigned to
Thank You so much Rick, this has been most helpful.
"BSc Chem Eng Rick" wrote: 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" "smck" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|