Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have a toolbar that is stored in the personal.xls workbook and is
created each time I start Excel (2003 for xp). There are three buttons - the first two have regular face id's, but the third I specifically designed a button icon for. I just have no idea how to assign that icon to that macro. I have saved the icon as a picture on sheet1 of my personal workbook (named "calendar"), but I get an error message saying the picture is not found. I also tried to activate the personal workbook but I kept getting more error messages so I guess I am doing it wrong. Any help is appreciated! Here is a snippet of my code: c = 1 fID = 2167 Sheet1.Shapes("Calendar").Copy For iCtr = LBound(MacNames) To UBound(MacNames) With .Controls.Add(Type:=msoControlButton) .OnAction = "'" & ThisWorkbook.Name & "'!" & MacNames(iCtr) .Caption = CapNamess(iCtr) .Style = msoButtonIcon If Not c = 3 Then .FaceId = fID Else .PasteFace End If .TooltipText = TipText(iCtr) End With fID = fID - 2100 c = c + 1 Next iCtr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom icon | Excel Discussion (Misc queries) | |||
custom icon in custom commandar | Excel Programming | |||
Custom Icon for an Excel File | Excel Programming | |||
custom icon buttons | Excel Programming | |||
custom icon buttons | Excel Programming |