Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make custom buttons point to local macros always Fabian Excel Discussion (Misc queries) 2 May 6th 09 03:24 PM
Assigning Macros to Toolbar buttons JMay Excel Discussion (Misc queries) 1 July 24th 07 07:22 PM
Assigning Macros to Buttons Christine Excel Discussion (Misc queries) 1 May 11th 06 09:42 PM
Assigning Macros to Buttons in Excel Ronnie Excel Worksheet Functions 2 July 20th 05 08:43 PM
assigning macros to buttons or autoshapes John of the new year Excel Worksheet Functions 1 June 10th 05 01:31 AM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"