Solved

How to store customized toolbar button icons in xla?

Posted on 2002-05-02
7
351 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:alanpong
7 Comments
 
LVL 1

Author Comment

by:alanpong
ID: 6988217
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
 
LVL 1

Author Comment

by:alanpong
ID: 6988336
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
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6990508
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 44

Expert Comment

by:bruintje
ID: 7064342
Hi alanpong any update on this? :O)Bruintje
0
 
LVL 1

Author Comment

by:alanpong
ID: 7064362
Bruintje, no update. I use the solution in my first comment.  I feel this solution is good enough.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7100091
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
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7118730
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now