[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to store customized toolbar button icons in xla?

Posted on 2002-05-02
7
Medium Priority
?
360 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
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

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.

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
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.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 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