Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

How do I change Backstage(File) view in Excel 2010 and higher

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


If you want to insert RibbonX into a Excel 2007 and up workbook to change the Ribbon, then I suggest you download and install the free Office RibbonX Editor created by Fernando Andreu to make this a lot easier : https://github.com/fernandreu/office-ribbonx-editor/releases/latest

Before Fernando Andreu released this tool we used a tool named Custom UI Editor created by Trang Luu, you can download it here if you want to test this very old tool, but I suggest that you use the new tool that Fernando Andreu created that is up to date.

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 Office RibbonX 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 there are example workbooks where you can look at the RibbonX.

 

What is Backstage view ?

In Excel 2010 and higher 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 Office Button was clickable.

Excel 2010

When you click on File in Excel 2010 you see 6 buttons and 6 tabs in Backstage View. 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. 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 and higher

When you click on File in Excel 2016 and higher you can see a different amount of buttons and tabs in Backstage View. The first image is from Excel up to date in Aug-2019 and the second from the first few versions of Excel 2016. Note: the names and idMso's in blue in the table are the tabs. After a Excel 2016 update TabShare is not working anymore to hide it and we must hide a new button named ShareDocument. And there is a new tab named Home that we must hide now named PlaceTabHome.

Name
Home
Info
New
Open

Save
Save As
History
Print
Share


Export
Publish

Close
Account
Feedback

Options
idMso
PlaceTabHome
TabInfo
TabOfficeStart
TabRecent

FileSave
TabSave
HistoryTab
TabPrint
TabShare
ShareDocument
TabPublish
Publish2Tab

FileClose
TabHelp
TabOfficeFeedback

ApplicationOptionsDialog
2016andup     

Example to hide all Tabs and buttons in Backstage view

Copy the RibbonX below, and with the Office RibbonX 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 and higher

Note if you use Excel 2016 and higher: 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.

<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"/>
        <button idMso="ShareDocument" 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"/>
	<tab idMso="TabOfficeFeedback" visible="false"/>
	<tab idMso="PlaceTabHome" visible="false"/>
    </backstage>
</customUI>

 

Download Backstage view examples files

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

File date 22-Aug-2019, 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