Solved

How to store customized toolbar button icons in xla?

Posted on 2002-05-02
7
353 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

786 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