Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Custom Toolfaces
Hi,
I have a routine in Excel 4 macro language that creates a toolbar with custom faces. These toolfaces are little bitmaps that reside on my spreadsheet and when I create the toolbar I copy and paste each on onto it's respective tool. I am looking to convert this routine into VBA and I am having trouble finding the command that allows me to paste my little bitmaps onto the tools. Can someone help me on this? Thanks, Eloy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Custom Toolfaces
Hi Eloy,
cbTable.Shapes(shapename).Copy*Picture cbCtl.PasteFace where cbTable is the codename of the sheet containing the picture, shapename is the name of the shape, such as 'Picture 30', and cbCtl is an object variable for the control being added. -- HTH RP (remove nothere from the email address if mailing direct) "Eloy" wrote in message ... Hi, I have a routine in Excel 4 macro language that creates a toolbar with custom faces. These toolfaces are little bitmaps that reside on my spreadsheet and when I create the toolbar I copy and paste each on onto it's respective tool. I am looking to convert this routine into VBA and I am having trouble finding the command that allows me to paste my little bitmaps onto the tools. Can someone help me on this? Thanks, Eloy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Text Lists copying, not filling | Excel Discussion (Misc queries) | |||
copying custom tool bar | Excel Discussion (Misc queries) | |||
Copying Custom Headers in Excel | Excel Discussion (Misc queries) | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
Copying custom views from one worksheet to another | Excel Programming |