How to store customized toolbar button icons in xla?

I'm making a xla and I want to create toolbar button with customized icons.  Therefore, I want to store some icons(gif/jpg/bmp) in the xla file so that I can make use of them while creating the toolbar button by code.

I know using add a form and an image control to the xla project may be (?) one of the solution.

Can someone suggest a better solution?
Thanks a lot.
LVL 1
alanpongAsked:
Who is Participating?
 
NetminderCommented:
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0
 
alanpongAuthor Commented:
The following code may save a picture inside the xla, through the debug window in macro editor:

Workbooks("my.xla").Worksheets(1).shapes.addpicture "c:\my.bmp",false,true, 100,100,70,70

But, can I do this through GUI?
0
 
alanpongAuthor Commented:
my solution is to rename the *.xla to *.xls, and then add pictures to the sheet.
if anybody can suggest a better solution, i will give him/her the point.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Anne TroyEast Coast ManagerCommented:
I don't expect this to be an answer for you, alan, but I was just wondering if you really need those external graphics. See this:

http://j-walk.com/ss/excel/tips/tip67.htm

It's a terrific little tool.
0
 
bruintjeCommented:
Hi alanpong any update on this? :O)Bruintje
0
 
alanpongAuthor Commented:
Bruintje, no update. I use the solution in my first comment.  I feel this solution is good enough.
0
 
bruintjeCommented:
Ok time to clean up

my recom will be
-PAQ
-refund points (asker used own solution)
-this will be finalized with no further update (29.06.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.