Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A little different interpretation of the question:
with the addin loaded, go to the VBE and select the addin in the project explorer window. Click on the ThisWorkbook subelement and in the properties window, change the IsAddin property to false. Now it will be a workbook and you can manually place your bitmaps/icons. Once done, you can change it back to an addin and save it. Regards, Tom Ogilvy "Robin Clay" wrote in message ... Greetings ! Earlier today I wrote in here ... I would like to create my own icons to go on other menu items. "Colo" kindly replied, 12/10/2003 1:32:47 AM, for which I am very grateful, Please place Auto shpas or bitmaps in the sheet1 before run this code. ..... Set sh = Sheets(1) ..... Set shp = sh.Shapes(lngCnt) ..... shp.Copy ..... .PasteFace These routines all go into my AddIn.xla, which I notice has a Sheet1. My further question, then, is this - Can I put these shapes into that Sheet 1 in my AddIn.xla ? And if so, how ? "Normally", I can't access that worksheet in the .xla file. RClay AT haswell DOT com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Addin for Access Links | Links and Linking in Excel | |||
How do I edit a worksheet that has been defined as an addin | Excel Discussion (Misc queries) | |||
Wie kann ich aus einem Access 2002 AddIn eine Excel Datei öffnen??? | Excel Programming | |||
Using UDF in COM Addin as formula in worksheet | Excel Programming | |||
raw speed for excel worksheet functions? - xll -or com addin? | Excel Programming |