Load different UI XML in a worksheet without closing it.

[gnaske]

I have a serious problem and hope somebody can help.


But first some background.
I work at a project for Bus Drivers and there will be three Admins at the project.

Using Andy Pope's Ribbon Editor, I had made a CustomUI XML Bus Tab and the Ribbon is for the drivers use.
http://www.andypope.info/vba/ribboneditor_2010.htm


The project will have all needed functions in the Bus Tab and because I don't want people to edit it the project at all, I want to hide most of the Excel's own UI XML Ribbon.
CustomUI XML - Editor.jpg
CustomUI XML - Bus Tab.jpg - Sorry the language in the picture is in Danish !


But because I want the Admins to edit in the project in an easy way, I had made an Admin Tab too.
Admin Tab.jpg -I actually made two different Buttons and they both works.

The Button in the Admin Tab is password protected.
Password UserForm.jpg

And the protected button open a Userform with two CommandButtons, to open and close the ExcelUI XML Ribbon.
Load diff UI XML.jpg


My serious problem is, and I believe it's more than just coding.
1. To load the CustomUI XML Ribbon, when the worksheet open.
2. To be able to open the ExcelUI XML Ribbon, together with the CustomUI XML Ribbon, using the UserForms Button.
3. To be able to close the ExcelUI XML Ribbon again and keep the CustomUI XML Ribbon back.

If it will be more easy in no. 2., only to load the ExcelUI XML Ribbon, without the CustomUI XML Ribbon, it's okay too, but to load both UI XML's would be fancy !

I have the idea how it should look, but to make it too, is way over my head !
I hope it's possible to make !

If anybody have a suggestion, how it can be made, I'll be glad.

Thank you in advance.

Ib

[gnaske]

I was actually thinking, when I generated the CustomUI XML, all the hidden Excel Buttons was visible="false".

If it was possible to change the visible="false" to visible="true" in the CustomUI XML and then refresh the worksheet, all Ribbons would be visible.
And then the other way around, to change it back to visible="false" and then refresh, when the other Button is clicked.

But the problem is, I use some of the Excel Ribbon and it's already "visible="true".
I can't figure out to make the code and I can't figure out at all, how to avoid the already "visible="true", to stay as they are, when it's swift back to visible="false".

Maybe it's needed to define the specific Tab which should be change.
- idMso="TabView" visible="false"/>
- idMso="TabDeveloper" visible="false"/>
- idMso="TabAddIns" visible="false"/>
- idMso="TabBackgroundRemoval" visible="false"/>
etc.

I think it could work !

Please look the attached.
Vissible=.jpg

Ib

[gnaske]

I knew this question was a hard nut to crack and therefor I contacted Andy Pope, who helped me.
The solution is already in Andy's Editor and with some help from him I understood how to make the settings.

Attached a little example, how an own Ribbon is made and how to show and hide Excel's Ribbon.

Thank you to all who looked at this threat.

Ib