Ok solved almost all of it. Cannot hide the File tab but otherwise it works as expected.
<!--
Hide everything on the ribbon (but the File tab called 'backstage', which will be empty).
Show the Quick Access Toolbar (QAT) with the Insert Picture command.
Tested on Excel 2010. No VBA code needed.
Insert below XML with the Custom UI Editor into an Office document:
http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx
Tutorial: http://www.rondebruin.nl/win/s2/win001.htm
-->
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<qat>
<sharedControls>
<control idMso="PictureInsertFromFile" visible="true"/>
</sharedControls>
</qat>
<tabs >
<tab idMso="TabHome" visible="false"/>
<tab idMso="TabInsert" visible="false"/>
<tab idMso="TabPageLayoutExcel" visible="false"/>
<tab idMso="TabFormulas" visible="false"/>
<tab idMso="TabData" visible="false"/>
<tab idMso="TabReview" visible="false"/>
<tab idMso="TabView" visible="false"/>
<tab idMso="TabAddIns" visible="false"/>
<tab idMso="TabPrintPreview" visible="false"/>
</tabs >
</ribbon >
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="FileSaveAs" visible="false"/>
<button idMso="FileClose" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileExit" visible="false"/>
<button idMso="ApplicationOptionsDialog" visible="false"/>
<tab idMso="TabInfo" visible="false"/>
<tab idMso="TabPrint" visible="false"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
</backstage>
</customUI>
Regards
Peter
Bookmarks