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

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

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