Hide Excel Tabs-Heading-Formula Bar on Opening

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.

Code:

---

Sub HideExcelItems()

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

End Sub

---

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

Attachment 16024

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?

http://www.vbaexpress.com/forum/imag...AAAElFTkSuQmCC
http://www.vbaexpress.com/forum/imag...AAAElFTkSuQmCC

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. ;)