assigning macros to several custom buttons
If you're referring to commandbar buttons and you want to
paste their customized images then I think you want the
ActionControl property.
Suggested is the following code. Assign the same macro to
all buttons on the toolbar. It works for any commandbar
button on any toolbar so long as it has a button image.
Sub PasteActiveButtonImage()
On Error Resume Next
CommandBars.ActionControl.CopyFace
ActiveSheet.Paste Destination:=ActiveCell
End Sub
Regards,
Greg
-----Original Message-----
Can someone help me with this one?
I have an objective to click one of several custom
buttons
and then the button image will paste onto an Excel
sheet.
The image is button size.
I have tried this using macros and I can make one button
image paste onto Excel, however, the same image pastes
onto Excel no matter which button I select.
Any suggestions?
Thanks for the help.
.
|