Solved

Office 2010 custom image not appearing in custom Ribbon

Posted on 2011-03-10
23
1,458 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

932 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

16 Experts available now in Live!

Get 1:1 Help Now