[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to store customized toolbar button icons in xla?

Posted on 2002-05-02
7
Medium Priority
?
362 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 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