Hide Excel Tabs-Heading-Formula Bar on Opening

[pivotguy]

I would like to have a full screen upon opening an excel file. Can you tell me where should I place the code
so that the workbook is displayed full screen with no Formula bar, heading and tabs etc.

Sub HideExcelItems()

Application.DisplayFullScreen = True
Application.DisplayFormulaBar = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayGridlines = False

End Sub

[Paul_Hossler]

In the ThisWorkbook code module, in the _Open event is the primary place, but you can flip the settings on and off if you switch between open workbooks

Capture.JPG

[pivotguy]

I added the code “This workbook” under sub procedure “OPEN”.When I opened the excel, I get a full screen, except the “excel” icon on thetop left corner of the screen. When click on the excel icon, I get belowdropdown. Click on Restore, bring back all excel icons, header etc.

How to remove the “excel” icon?

[Zack Barresse]

You can't remove the icon. I think I remember seeing some wild API calling a while back by Ivan Moala regarding this, but it's very fuzzy and I couldn't find it on a search. My suggestion is to leave that one alone.