Ribbon in 2010

[Brutium]

Hello all....
Is it possible to save a modified ribbon using VBA so that I do not need to go back to Options to change it back to my likings everytime I use the same workbook?

 

[PoggiPJ]

Hello all....
Is it possible to save a modified ribbon using VBA so that I do not need to go back to Options to change it back to my likings everytime I use the same workbook?

Bump! I would like to be able to do the same.

 

[biz_kid1]

I was under the impression that any customizations you made to the ribbon stayed in place once you made them. Are your changes not staying?

 

[Brutium]

Hi,
I posted this question LOOOOOOng time ago, but the pro blem is still the same.....

What I need to do is have ONLY the file tab present on one program I created. I do not want to have the users of my program to gain access to any other tabes. What I want to accomplish is make sure that the use will only be able to save the file, Save As, and Print the file, nothing else. The nprogram is a school marks management program and I do NOT what the users (teachers) to do anything to the spreadsheet. All they will be allowed to do is input marks, and then save the changes and print the sheets they are working on. I do NOT want them to do anything else.

To answer your question, yes the customization of the ribbon does change, but I do not want it to change for anything else.

 

[biz_kid1]

You'd probably need a custom XML for the workbook instead of VBA. You want more information on that?

 

[Brutium]

YES, Please....

 

[biz_kid1]

I'm at work and can't test it, but can leave you with this info for now. If I have time over the weekend, I'll see if I can't play with it more for you...

Start with these links for “how to” directions: </SPAN>
http://www.rondebruin.nl/ribbon.htm </SPAN>
http://www.rondebruin.nl/ribbonx20072010.htm </SPAN>

This tool can help as well - Custom UI Editor Tool: http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/26/customuieditor.aspx </SPAN>

Additional Resources:</SPAN>

http://www.tvmcalcs.com/blog/comments/modifying_the_ribbon_in_excel_2007/</SPAN>

Adding Custom UI to Excel 2010 Worksheets by Using the Open XML SDK 2.0: </SPAN>http://msdn.microsoft.com/en-us/library/hh832141.aspx </SPAN>

 

[biz_kid1]

My apologies...last weekend I had to reformat my computer and this weekend we'll be out of town, but I haven't forgotten about this (if you haven't already figured it out).

 

[biz_kid1]

See if this is what you're after!

http://christinashaw.com/wp-content/uploads/2012/07/Book2.xlsx

If not, I'll see if I can't tweak it more.