Now that we have 'upgraded' to Access 2010, starting a new adventure in ribbon customization. It was working great with Access 2007. Now with Access 2010 I have that red File button exposed to everyone and I don't want that. According to my research, Access 2010 ribbon customization with XML code requires a new schema reference and code tags for the 'backstage'. http://www.accessribbon.de/en/?New_F...in_Access_2010
This is my 2007 XML:
Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" >
<commands>
<command idMso="Help" enabled="false"/>
</commands>
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</officeMenu>
<qat>
<documentControls>
<button idMso="DataRefreshAll"/>
</documentControls>
</qat>
</ribbon>
</customUI>
This is the 2010 XML:
Code:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="OnRibbonLoad" >
<commands>
<command idMso="Help" enabled="false"/>
</commands>
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</officeMenu>
<qat>
<documentControls>
<button idMso="DataRefreshAll"/>
</documentControls>
</qat>
</ribbon>
<backstage>
<buttonidMso="FileSave" visible="false"/>
<buttonidMso="SaveObjectAs" visible="false"/>
<buttonidMso="FileSaveAsCurrentFileFormat" visible="false"/>
<buttonidMso="FileOpen" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
<tab idMso ="TabInfo" visible="false"/>
<tab idMso ="TabRecent" visible="false"/>
<tabidMso ="TabNew" visible="false"/>
<tabidMso ="TabPrint" visible="false"/>
<tabidMso ="TabShare" visible="false"/>
<tabidMso ="TabHelp" visible="false"/>
<buttonidMso="ApplicationOptionsDialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
</backstage>
</customUI>
Some of the 2010 version works. Issues:
1. the button for Options is now labeled 'Privacy Options' but opens the same Options dialog as if there were no restrictions
2. the Exit button is still visible
3. the Print tab is still visible
4. the QAT is not configured
5. the VBA procedure called by the ribbon onLoad (I also tried OnShow) method doesn't run, this procedure calls Login form
If I keep the 2007 XML active, 1,2,3 are still issues, but 4 and 5 are not. So I gain nothing and actually lose functionality with the 2010 XML.
I don't want to publish db as runtime or executable - that opens another can of worms I don't want to deal with.
Anybody know how to fix the XML for 2010 custom ribbon?