Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for that Tom - I think it will work in XL2000 as well
(hopefully). I was using the copy and pasteface methods but was having problems with Excels clipboard when switching between workbooks - I was wanting to redraw the toolbar enabling/disabling functionality depending on what type of workbook was open. I was refreshing the toolbar on the sheet_activate events - the copy and paste face was messing up Excels clipboard. I tried storing the clipboard contents in a DataObject before copy the images then putting it back in but this was crashing Excel. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just checked - no Picture property in XL2000 - so back to square one
really. Thanks anyway. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the dataobject only holds text strings.
You just need to put your images on a worksheets, then you can select them, do copy, then use pasteface to put them on you toolbar. Alternately, you can put them on a dummy toolbar attached to your workbook and do copyface to get them and pasteface to transfer them. Sub Test() Dim cbrMenuCtrl As CommandBarButton ' image on worksheet named Init, first shape in the shapes ' collection for example (or give it a name) Worksheets("Init").Shapes(1).Copy Set cbrMenuCtrl = Application.CommandBars("Tools").Controls.Add With cbrMenuCtrl .Caption = "Hello" .OnAction = ThisWorkbook.Name & "!blabla" .PasteFace End With End Sub -- Regards, Tom Ogilvy "MarkHG" wrote in message ups.com... Just checked - no Picture property in XL2000 - so back to square one really. Thanks anyway. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lose custom toobar settings | Excel Discussion (Misc queries) | |||
Lotus had buttons (icons) for first & last cell does excell? | New Users to Excel | |||
Icons on buttons | Excel Discussion (Misc queries) | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming |