You can also Use XML
See this page for a example
http://www.rondebruin.nl/ribbon.htm
In the XML examples (number 2)
you can find a dictator example
<customUI xmlns="
http://schemas.microsoft.com/office/2006/01/customui">
<!-- **************************************************************************-->
<!-- ****Disable 'Exit Excel' and 'Excel Options' on the Office button menu****-->
<!-- **************************************************************************-->
<commands>
<!-- Disable Excel Options on the Office button menu-->
<command idMso="ApplicationOptionsDialog" enabled="false"/>
<!-- Disable Exit Excel on the Office button menu-->
<command idMso="FileExit" enabled="false"/>
</commands>
<!-- *******************************************************************-->
<!-- **********Set startFromScratch to true to hide the ribbon**********-->
<!-- **********Hide New, Open and Save on the Office button menu********-->
<!-- *******************************************************************-->
<!-- Set startFromScratch to true to hide the ribbon-->
<ribbon startFromScratch="true">
<!-- startFromScratch="true" hides all of the ribbon tabs and it hides the QAT. -->
<!-- It also hides most of the commands on the Office button menu, but for some -->
<!-- reason, it does not hide the 'New', 'Open' and 'Save' commands. -->
<!-- So if you want to hide them you have to add this to your RibbonX file: -->
<officeMenu>
<button idMso="FileNew" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false" />
</officeMenu>
<!-- You can add xml here to create your own custom tab on the ribbon-->
</ribbon>
</customUI>
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
Rick Rothstein (MVP - VB) said:
Minimize the Ribbon? Do you mean *hide* the Ribbon? If you execute this
line...
ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", False)"
in the Workbook_Open event, and if the user Enables Macros, then the Ribbon
will be *hidden* at startup. If you ever want to bring it back via code,
change the False to True.
Rick
