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
Solved

Office 2010 custom image not appearing in custom Ribbon

Posted on 2011-03-10
23
1,547 Views
Last Modified: 2013-11-10
Hello,

My custom image does not appear in my Ribbon.  The button appears but without the image.  I've attached a screen shot of the "Custom UI Editor" with my xlam file open.  The image is called BlackFolder.  I tried other images but they did not work either.
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
	<ribbon startFromScratch="false">
		<tabs>

      <tab id="CustomTab" insertAfterMso="View" label="VR">
        <group id="SIMON" label="SIMON">
          <button id="Button" label="Consolidate" image="BlackFolder" size="large" onAction="ThisWorkbook.DataFix" />
        </group>
      </tab>		
		</tabs>
	</ribbon>
</customUI>

Open in new window

ribbon-image-problem.bmp
0
Comment
Question by:eshurak
  • 12
  • 11
23 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35101483
If I am not wrong, there is no image called "BlackFolder". Could you please show me how does it look like? Or choose the right one from this file. You will see all the icons in the File menu ~~> ImageMso 0 and ImageMso 1 (Right at the bottom)

Alternatively, you can download the same file from here

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2d3a18a2-2e75-4e43-8579-d543c19d0eed

Sid
Office2010IconsGallery.docx
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102037
Hi Sid,

I'm using image not imageMso so it's for a custom image not a MS build-in one.  See here they use a custom image in their ribbon.: http://msdn.microsoft.com/en-us/library/cc508991%28v=office.11%29.aspx

Thanks
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102136
Ok. Can you upload that image here. Let me create the XML code for you.

Sid
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102156
Also I hope you have read this on that link

Note:
In the following procedures, you import an image of your choice into the Custom UI Editor. As a rule of thumb, images should be either 16 X 16 for small controls, or 32 X 32 for large controls, both with 96dpi. These images can be one of the following formats: PNG, BMP, ICO, WMF, JPG, and GIF.

Sid
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102180
Yes, I'm png file is 32X32 and 96 dpi.
blankFolder.png
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102495
Ok Test this for me. Some files are getting uploaded onto my FTP server so I cannot restart my laptop in win 7 to check this in Office 2010. Also Use the image that I am uploading. Insert that image using Custom UI.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
	<ribbon>
		<tabs>
			<tab id="MyCustomTab" label="VR" insertAfterMso="TabView">
				<group idMso="GroupClipboard" />
				<group idMso="GroupFont" />
				<group id="customGroup1" label="SIMON">
				<button id="customButton1" label="Consolidate" size="large" onAction="DataFix" image="BlankFolder" />
				
				</group>
				<group idMso="GroupEnterDataAlignment" />
				<group idMso="GroupEnterDataNumber" />
				<group idMso="GroupQuickFormatting" />
			</tab>
		</tabs>
	</ribbon>
</customUI>

Open in new window


Sid

BlankFolder.jpg
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102596
BTW, I have tested it in 2007 and it works. :) See snapshot. I will be able to test the above code after an hour once the uploading of files is complete.

UI For 2007

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>    
<tab id="MyCustomTab" label="VR" insertAfterMso="TabView">			
  	  
<group id="customGroup1" label="SIMON">
<button id="B1A" label="Consolidate" size="large" onAction="DataFix" image="BlankFolder" />
</group>
   
</tab>
</tabs>
</ribbon>
</customUI>

Open in new window


Sid
Untitled.jpg
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102655
I used your code and jpg file but still the image does not show up.
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102676
Just saw your second message.  I guess it's an 2010 issue.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102682
Ok. Can you test this file for me? If it is not working, then I will only be able to test it after as hour like I mentioned above..

Sid
Sample.xlsx
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102720
Yes, that works.  So it's not in my xml.  I'm attaching my xlam file.
Williams-Consolidation.xlam
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102736
Don't give me this. Give me the original xlsm file so that I can amend it.

Sid
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102814
That's all I've got at this point.  I'm hoping to see where I went wrong so I don't repeat my mistake.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35102895
Ok Try this

Sid
Williams-Consolidation.xlam
0
 
LVL 3

Author Comment

by:eshurak
ID: 35102994
That does not work either.  Maybe it's something in the .rels file or customUI.xml.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35103017
Is it not your original File? If I can get the source (xlsm) then I can get it working for you.

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35103096
Wait.

I have an alternative :)

Sid
0
 
LVL 3

Author Comment

by:eshurak
ID: 35103121
Okay,  I was able to move my code to your sample and rename it.  I also made my xlam work by copying the customu14.rels file from your to mine.
0
 
LVL 3

Author Comment

by:eshurak
ID: 35103131
I'm going to close this one down unless you want to keep working on it. ;)
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35103132
Check this file. I created the xlsm file for you.

If it is working then save it as an Add-In :)

Sid
Williams-Consolidation.xlsm
0
 
LVL 3

Author Comment

by:eshurak
ID: 35103150
Thanks Sid!!!
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35103154
Glad to be of help :)

Sid
0
 
LVL 3

Author Closing Comment

by:eshurak
ID: 35103155
We still don't know what caused the problem but I least we got it working.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 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