?
Solved

Excel 2007 Ribbon: Button Alignment

Posted on 2011-10-22
7
Medium Priority
?
1,433 Views
Last Modified: 2012-05-12
Hi Guys,

I have a client who uses an a custom designed xml ribbon within Excel 2007.

They have requested one of the custom buttons be aligned to the far right of the ribbon. Having scouring the web, it looks as though everything is defaulted to the left and is difficult to pull off.

Is it possible to have this functionality, or have to settle with M$ ribbon restrictions?

Hope you can assist :)

Possible Solution
http://www.access-programmers.co.uk/forums/showthread.php?t=186925

Here is my current xml code:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab id="Tab5" label="Timesheet">
<group id="Group5" label="Macro Buttons">
<button id="Custom_Btn_Macro4" label="Chargeable" size="large" onAction="CallControl" imageMso="FunctionsStatisticalInsertGallery" />
<button id="Custom_Btn_Macro11" label="Service Charge" size="large" onAction="CallControl" imageMso="InternationalCurrency" />
<button id="Custom_Btn_Macro10" label="Stop" size="large" onAction="CallControl" imageMso="CancelRequest" />
<button id="Custom_Btn_Macro12" label="Archive" size="large" onAction="CallControl" imageMso="LoadFromQuery" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>
0
Comment
Question by:icuadmin
  • 5
7 Comments
 
LVL 11

Expert Comment

by:Swapnil Nirmal
ID: 37013251
0
 
LVL 1

Author Comment

by:icuadmin
ID: 37014306
Guys I figured it out, thanks for the response.
0
 
LVL 1

Author Comment

by:icuadmin
ID: 37017734
I've requested that this question be deleted for the following reason:

Figured the problem out myself
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 37017638
It would be nice if you posted the answer and then accepted your own answer, rather than just deleting the question.
0
 
LVL 1

Accepted Solution

by:
icuadmin earned 0 total points
ID: 37017677
Ok, I figured if you insert a blank button exluding any label xml code, if you create enough of them then it will align to the far right of the screen. This was through trial and error and studying the code hard enough.

Notice the space between the " ", this is very important.

e.g.
<button id="Custom_Btn_Macro4" label="" size=" " onAction=" " imageMso=" " />



 
0
 
LVL 1

Author Comment

by:icuadmin
ID: 37017735
I wish revoke to deleting the question by mistake. I have posted the answer to help others also.

Thankyou
0
 
LVL 1

Author Closing Comment

by:icuadmin
ID: 37049186
Fixed this myself, thanks for your help anyway guys.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

593 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