Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

How do I change Backstage(File) view in Excel 2010-2013

If you want to insert RibbonX into a Excel 2007-2013 workbook to change the Ribbon, then I suggest you download and install the free Custom UI Editor to make this a lot easier : http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/26/customuieditor.aspx

Note: If the link is broken you can also download the Custom UI Editor from my site.

Note: It is not possible to insert RibbonX into Excel 97-2003(xls) files.

When you open a Excel file in the Custom UI Editor you can right click on the file name and choose :
Office 2007 Custom UI Part Or use Office 2010 Custom UI Part
We choose Office 2010 Custom UI Part because Backstage is new in Office 2010 and up.

It creates the customUI14.xml file if you choose Office 2010 Custom UI Part and you can enter or paste your RibbonX in the right window.

Note: the button caption "Office 2010 Custom UI Part" is no longer correct since Office 2013 has been released. It should now be named "Office 2010-2013 Custom UI Part" but I do not think they will update the editor for this.

 

What is Backstage view ?

In Excel 2010-2013 you notice that the big round circle in the top left corner named Office Button in Excel 2007 is changed to File because a lot of people didn't understand that the Ofice Button was clickable in Excel 2007.

Excel 2010

When you click on File in Excel 2010 you see 6 buttons and 6 tabs in Backstage View (the Backstage view is full screen). Note: the names and idMso's in blue in the table are the six Tabs.

Name
Save
Save As
Open
Close
Info
Recent
New
Print
Save & Send
Help

Options
Exit
idMso
FileSave
FileSaveAs
FileOpen
FileClose
TabInfo
TabRecent
TabNew
TabPrint
TabShare
TabHelp

ApplicationOptionsDialog
FileExit

 

Excel 2013

When you click on File in Excel 2013 you see 3 buttons and 8 tabs in Backstage View (the Backstage view is full screen). Note: the names and idMso's in blue in the table are the 8 Tabs.

Name
Info
New
Open

Save
Save As
Print
Share
Export

Close
Account
Options
idMso
TabInfo
TabOfficeStart
TabRecent

FileSave
TabSave
TabPrint
TabShare
TabPublish

FileClose
TabHelp
ApplicationOptionsDialog

 

Hide all Tabs and buttons in Backstage view

Copy the RibbonX below with the customUI editor in the customUI14 file. Note: if you have a add-in installed that add stuff to backstage you will still see this. There is no StartFromScratch option like we can use for the Ribbon to be sure we start from scratch. In the download below there is also a example file for with the example below.

Note: The RibbonX below will work in 2010 and 2013

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <backstage>
        <button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
        <tab idMso="TabPublish" visible="false"/>
        <tab idMso="TabSave" visible="false"/>
        <tab idMso="TabOfficeStart" visible="false"/>
    </backstage>
</customUI>

 

Download Backstage view examples files

You can download a zip file here with a few test workbooks.

Note: Microsoft makes it not easy for developers for making solutions that work in 2010 and 2013 because they changed a lot of things including names of existing idMso's.

17-March-2013, 6 files
Download example files

Important:
If you have also other xml that change the Ribbon add the xml for Backstage then above the last line </customUI>
It will not work if you add the backstage xml above the xml that change the Ribbon.

 

Ribbon Examples and Tips

Visit this page for tips and more examples : Ribbon Examples and Tips