Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

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

If you want to insert RibbonX into a Excel 2007-2016 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.

Open an existing Excel file (must not be open in Excel) in the Custom UI Editor and right click on the file name and choose : Office 2007 Custom UI Part Or 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-2016 Custom UI Part" but I do not think they will update the editor for this.

 

What is Backstage view ?

In Excel 2010-2016 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

Excel 2016

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

Name
Info
New
Open

Save
Save As
History
Print
Share
Export
Publish

Close
Account
Options
Feedback
idMso
TabInfo
TabOfficeStart
TabRecent

FileSave
TabSave
HistoryTab
TabPrint
TabShare
TabPublish
Publish2Tab

FileClose
TabHelp
ApplicationOptionsDialog
OfficeFeedback

Example to hide all Tabs and buttons in Backstage view

Copy the RibbonX below, and with the customUI editor paste it in the customUI14 file that you just create in the UI Editor and save/close the file. Now open the file in Excel and if correct the File menu is empty. Note: if you have a add-in installed that add stuff to backstage you will still see this customization. There is no StartFromScratch option for backstage like we have for the Ribbon to be sure that 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-2016

<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"/>
        <button idMso="HistoryTab" visible="false"/>
        <button idMso="OfficeFeedback" 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"/>
	<tab idMso="Publish2Tab" visible="false"/>
    </backstage>
</customUI>

Note if you use Excel 2016: Be sure that you not have "Show Add-in user interface errors" checked in File>Options>Advanced>General. You get errors that it can't find some Id's if you have it checked.

 

Download Backstage view examples files

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

File date 28-April-2016, 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