Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More - EQ 81

How to hide every single part of the Excel interface with the click of a button!

This allows you to make really good looking professional interfaces without having to resort to UserForms.

In this tutorial, you will learn how to hide these parts of the Excel interface:
- How to hide the Ribbon Menu.
- How to hide the Quick Access Toolbar.
- How to hide the formula bar.
- How to hide the status bar.
- How to hide the worksheet tabs.
- How to hide the column and row headings.
- How to hide the horizontal scroll bar.
- How to hide the vertical scroll bar.
- How to make the worksheet full screen.

Basically, everything will be gone except the title of the workbook and the barline, maximize/minimize, and close buttons on the top of the application window.

Excel Courses:

#msexcel #excelquickie #tutorial

[therealforexhack]

Wow, recently used this on my excel spreadsheet. You are the best. my YouTube video is now cleaner. THATS ALOT.👍

[ambirdReal]

Thank you soo much exactly what I needed 👍👌

[wayneedmondson]

Nice one! Thanks for the tips :)) Thumbs up!!

[DennisYeadon]

Thank you I can use these features individually and collectively.

[davidlovins]

Can this be used to remove specific items from the Ribbon. For example the Refresh All option or the entire Queries and Connections section under the data ribbon.

[oujvyxo]

How can I hide the excel top logo and file name with a macro? in this case also the minimize buttons (minus sign and small square) will be invisible.

[notNickWoz]

Been doing this for years.

Pro tip: put this on an “open” sub, so it runs whenever it opens the specific excel workbook and the show all on the close, so it resets it back.

[VINAY_DEVADIGA]

Is there a way to hide / disable only the Power Pivot Menu bar and not the entire Menu bar?
The file structure protection does not help to disable the power pivot window

[rltidd]

I wish to have this open online. Whenever opened show as you have this. How would I do this?

[emrek.]

how can i hide all rows and colums for the all pages in excel? i mean i have 5 pages and i want to hide all headings at the same time.is it possible to hide rows and colums inactive pages in excel?

[kolavithonduraski]

thanks for that awesome Video.

If i do this, it manipulates every excel instance i open... is there a possibility to use this only on that specific workbook ?
And the other excel-workbooks stay the same as they were before ?

[dhananjayarajakaruna]

Is there any way to open excel without tool bar ?

[GdarkWoW]

Is there a way to hide it when ever you start that file by default. So any time I run that file its hidden without me having to run it as macro ?

[miscuse]

Hi, just discovered this video. Great tutorial but i'm beginner in excel so i want to solve my problem but can't find the right keywords for the problem.

Here's the idea : Whenever i input number/text to spesific cell (ex : cell A1) then the cell move automatically to the next row/column so i can input the data without click the next cell manually. How i do that? With macro or not? Hope you or whoever saw this comment understand and can help me. Thanks

[TurboJet]

I just add a boolean variable to the Sub. So: *Sub
Then at the end of each of line, add *= lblnVisibleState* instead of true or false.
So you just call the *HideInterface* Sub and put "True" or "False" after your call.

[lozecmb]

I do not see the same information when clicking on module that is shown. I do not even get the module option to see the information that is being shown. Trying to hide everything on excel document to have a clean looking dashboard but this doesn't seem to work with multiple hidden sheets and pivot tables.

[chadeefouad]

A bit of a modification 1 sub instated of 2...this will toggle the status
Sub Toggle_Hide_Excel_Interface()

'Shows/Hides the Entire Excel Interface
If ActiveWindow.DisplayHeadings = True Then Setting = False Else Setting = True
ActiveWindow.DisplayHeadings = Setting
= Setting
= Setting
= Setting
Application.DisplayFormulaBar = Setting
Application.DisplayStatusBar = Setting
"show.toolbar(""Ribbon"", " & Setting & ")"
End Sub