LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Access to Worksheet in AddIn.xla

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
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
Excel Addin for Access Links Jim Normile Links and Linking in Excel 1 July 22nd 06 11:52 PM
How do I edit a worksheet that has been defined as an addin Guy Normandeau Excel Discussion (Misc queries) 3 June 30th 06 07:00 PM
Wie kann ich aus einem Access 2002 AddIn eine Excel Datei öffnen??? Marcel[_3_] Excel Programming 0 December 3rd 03 09:15 AM
Using UDF in COM Addin as formula in worksheet Ralf Zimmermann Excel Programming 1 September 3rd 03 02:09 PM
raw speed for excel worksheet functions? - xll -or com addin? John Doe[_3_] Excel Programming 1 August 18th 03 11:26 PM


All times are GMT +1. The time now is 03:58 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"