Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make custom buttons point to local macros always | Excel Discussion (Misc queries) | |||
Assigning Macros to Toolbar buttons | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions | |||
assigning macros to buttons or autoshapes | Excel Worksheet Functions |