PDA

View Full Version : Hide Excel Tabs-Heading-Formula Bar on Opening



pivotguy
04-26-2016, 12:54 PM
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
04-26-2016, 04:39 PM
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

16024

pivotguy
04-27-2016, 10:15 AM
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/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYwAAAAVCAIAAADaRU4iAAAAAXNSR0IArs4c6QAA AmZJREFUeF7t3D9IG1EcwPHLpbGuDjqISv0zCGId1JaK0qnFqBRBhyIdWsVBRxWLixS6FUQQB4c uUiGQoeASUMyiHTrZQdHEtIkVEw2KpQZRseb64kEQFHwQOfIu3 Ny3HJ3v9/nd/x4vMudwzAMjQUBBBDIVgGHTJM6uzgPxXfWdkPBWDi4F9mMhv eJDTD2J7yZ2texIUAAjYRuKNJDXz5GNiP/D6MaYZmJMUvtV7taGLH4XKmGVzOB2 aOsY7B20CQxoIIJAdAnc0qcqxttRQK7Xe0qSuj6QuLv/VjL3a uTLjryIAgEEbCKgZ5JH fBLcbjYilWMpESfyuRsHIsAAgjcFJBqUq fuL2DE6IN5bseLr7/PNP3wTxRZGLR3Jo7LAgggMC9C0g1qd0/8YZHNe7HLV2NLyoKSyd9s2Yc10dS9x4ZJ0QAAQSEgFST hZaXY Gep619z/vnv/hFw/4GElx9yCAgDUCUk1KhDLt9zytqC0uKJpamEtHxkjKmiJxFQRyWUC2SQmjy2RSd h5TlfaizmpXL51yB0BawSkmpRT10fdvb615fjx4VDbW0ZS1tSGqyCAgOycVFe9mC8vmfF7Z1fmW 2ub68qqmZPi7kEAAWsEpEZSVUVlX1eXNmK/PN99B4mjkfZ3ZnDMSVlTJK6CQC4L8I/zXK4 uSOggEBGTYp39xSoMCEioLhARi8Y8xUExatP AgoICD7qZbA3raYk9qI/gzGIoFoOHF6wqdaFCgvISKgvoBUk1I/TTJAAAFVBaSe7qmaHHEjgID6AjQp9WtIBgjYWoAmZevykhwC6gv8B4/HJ88x1pVCAAAAAElFTkSuQmCC
http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFIAAABDCAIAAACAxMXyAAAAAXNSR0IArs4c6QAA DcRJREFUeF7lW3lsFNcZn2NnZi/b6/vkMldisDEQAqRBJUqkVE2bQ2oq9Q kRmraSkmlCjVSpVZVq6j/RCqJUNMkakmbJkoKBAF2Y4442OawwdgGFnzi22tje71ee /dmdnt782YZb2sIZMYdq0 wXp2583M 73vve/7fcfQXV1dNE1TSmNoRsey EpT5H9QDIUjEfVUXGNYhmHmrlJPRSIRWQon7JxSP3Ict2rVKrq vr6srEySpJQa3AMaDGTV19e3fft2 vLlyxUVFaFQ6B5PgiQhdk6nk2X5AQ3o4dxWp9NhdZeXlzMEkpZGMyzP81jgWi5Klb4AGwwGR0dH mbhpxp7GGLHm8ZloS9PDHa1Vx4 3D02RzU3jH1EDaiNfKIomv5O/isrAr rXlGgYs9frtVqt8bAxus7OTmz4qqoqu92OfjHjpTlOaqw 5Zelo// 3EXpAh5XSKLCYsDj97TWHDlxrpvjdS7ndFCisBp8Xl YCntdLkkG pSAjUGIouh2u9lXX301Pz9f3bSCIBw9evTYsWPDQ0O5eXkFBQVZWVmq2KHQWahvNny9oa5nKlBa uTXb3/vOXz7otLvbm2t7JmaHL55rnaYyvb2fH/uqc3gyPNn52bFWyjfw4Qcf94dMj20oxa5IOnTs7d7eXsCeJ23IdmRkZPXq1aIk4Rw6xQ00QkVYI X1VSYGgo7svN8t5q0pX5D y9hGejqwsf yFp3b2W4df MWvSvnRXpvrsV07J6xW85oNy/PSoRKTjlkdAAyYwWCYBxuCheQbGxsn7fZdu3YtX748zrBFwpQlv/g733vOPDsorNmUx/iDoUjI7x7onbQUZ16 0rxu29pjf33bYdxcvq7EZEp7/OknWbdLDmPNpwpslWLQzc3NUOhRAxalLuppdYZiDdjtDhHoLlkMKvs2QrQ7x AmHC EAn6doIeFgIBZlsFXmWJ4Ln7hJEX42MUNDQ1OpzNepQFhtCUc2e2zFOwew3KAy3E8y1CyHGZZXV iWdRxPjBuZsghUhtIlJTDHwkmgyZMih4f80P9H2IRiaJ1mhaUoVpgwEc2Xa33covfHJnW5XNrGD bwzDrvHLwJxOOidnJqGZlv0kT3QG0JmZrNZE2ya1VGdTQ3nr/VCjw12XDxV1xbhOFkUCXhYBeh0HNGUYvZSdzo0L3JYJWOGJexyTDkdU26xMCdjtOdaQ8PZS61Xr 1mvz3r83R3WrhtXTtecutY/Buv1QOX2bW6ueWQRWlhWZGltbDblrzDrxMEB 6Zdu9PCLk7gO9utjCFtfHBYyMoWGFjubzOwB3utRtgRitfrC4qXmQzGoqJ8QW9esSL72rmzPr5w/doSz7Q7r2RZ6epltCRzqWeroxNJtHIcS1uIotwJM5DtSwJK4OdwLnAUCgZ1vEA88EiYJj9QwWCA YnScjn2wItN d7C0M2fODA0NaZS2YrdAvzALqvbCH9Aw5W8Errd6ChQ1BTErY6fBoBOQU 0zuMSuQGgoJydHu7SXGMz44ULg6enp2mHTNKsElZcoRVOHrRE2Im1Bz8DAkNvrdTpniB 9NJsW2JAzJV5vvTLlds 6ffA0w2FZcTCh0cjf1AmY3VcWWmATgIxg4MIyk5ttGh yDfW2f1F9ot820lT3Vd2FVp 8ZIBrgY2wQZgp27KjUHBfaLHOzHqz80vWPFpmDE7ZnCGTiZfFpYFbKyeHmyr3d1r7JnxZGelGI9 d1tWV4dELkzLkWI8frOZZOYT46t/CBGTFjjSwNQSOQMiliNBpwKEuiKMm83kDLoYAYMRj089OB991iD7sDWBoCpOfPn9e0yEm4nOX1J qMBrAyWgBf0JpNJx9A6Xm82GVIcc3SOoYo1wsalSgxRvYUaTow9eNji 0bP07q3v9FDUvIizdJmED2Yi6XhUMnuRzkLDPtd0TV0SimzBn2GtI822AAwPTnu8otAGwl6x5E9 GR/3BsNqblMOeMbGHYgtRQUMUmcfG/OF4JylUENETBNsmtdT1fvf uB4o8Fkajn54e/e/NAVEOUIrSNSZ mw6Pb4WB2HBUDyZ/hkGa/bLZJskELiSZhpLh cxGmAPpqX8VQ90miLHZma8aQZaeCqdWjcW1a oulsA28ozuTlGcfI4Y8Onm5sy11eNN470n2pvvrk6UvW9ua6kyOyhZ8aG7OPfPqPAzbZPH7xxGd VjYUbK/JMXFJygRAGYgyBQCBe2lj6AT9 Jy2qse/gR 6Ps2zamHfoo08yVlcUprG2/n6bbdS0Ytuz67Otbe3DgzbbsGPXi89Hxma//6MX7W1tXZ19mcvLKx/f9uQqoaqmJSOLc7t8sZm2pIh9HmxY85qamtdee22v0iYmJqC05g2L2G3 0fLNIW9oQ8VGxFCw2g0Gc0Fupgm8TdAbTQZLTm6mJaMor8BgMmSajWlZmTfqjtRd6hlwBis2lZr Tc7PMfIIJfYjoyXKOjaXhq99PZK2OIS0tTYUdm/EUg0EWkTOYayYSCkqqMoMDy6D4A E1kvCL6HidFJLUT0IGQz6P18 ZLOm8PDHlsuTkmQQ2KXFVyBUUjdSk3Z3oja7AaPlKXKKXhM1IJoB8JhRSfAelrAUBRzX4CHc1KZ gx1AVDiLGFSwtBUuUfJWexueFY3nanA4DCOyfnyEGyMKsKG/bkG0VOH ImXPRHYeIhcFJgpvXWinlTLrpzdOce0ZPzf0ohtoLllp2dnaAuLaHdVmEAcMDvEyVlV8uizw/lF8PJKMrv9YTkWKebuKRefzB1Ak6AXVhYOA 2Gj1HjRKax O5qyKPZDytZ2svXO9HSsDWdan6VJPM6rBb5hpL 71eMUzpCGtTiBvLomrN5w8pewqVvEpLNkcHrnksDaPEdkdDqZ7NZkMYHdtAlbPK0ihKttuG7LNi cUlOX09XmM3KTZOaLrYEQqLDPjPrnEJoURK9N1qvDYwMT46PdQ/csliMzsmZ0aH2ts6xdL3c0tQySwkF2RmKrXvYLTFLw47HGiguLt68ebPRaExUWAv bSrOM11tbhWyii16yuPyBTzOmSDrn gYDQiUd8bhcEh8TrGFpdOL83TBkdFbM75wSUnxmtUrxno6nCHJ5/UmA/K8KY7f25gPVKK2tLSAtCQ2yzRTWFLi93gLSgo5Onzr1gRvTA8HnLKQpw85/WEUaPLpGWZQN7NBEAwCy3K05G5rue70eEyZ2aBtOZkZyupJZounKyRAptSWAzMcNBV5LF2RQiFG KcHCkhfFMB2RPP6QXuAYHQ8PTI6gEJ8htAT5T4TVw6RsDcY6GPSLMmOxmD2zM2Gd3mI2JQX5gnV pkLZeaeiRUNqcQHK6LEniMqQoTTBkZVoMBiP4OS8giCiQOjUOMsYH5oeUrQl6fYYlKyfbwtAs/malJQdz7Or6JuV4cSxNqb2La3M8LvqrWlBO0sBzlXrJXOF4tma6kuTxLtLjNcCOpeup8jqAxnFE HV4NsG/z0dgAzBI7vs01tVQhgsws9aYmtyFzDdLWuKBSsTswg4/U1tZqgD2nTWiSA9ILsEzERC2SirnPbVD2hCeiEywiCdPPZ/V4WUlPTCcqh0iBFIa20O0gbbgbBw4c0OaBgYawkre2 j Hqr9sbb5wbdCO jOSLyBRJeJ8kPpbkjNYTE8TN5zqu3K0ph5 X1tT/ZDDjzICFTkJG7CMZ7L/8CefHDzREKS46f6rX5y/Cp/n3hMZ74GpsTTET GNxF9J0wJHH3r/zS 7XOtW5n918P1jFweoIFICUwiL 2edY5MODGh6cmLWG1xE5LyO uLjfXv/8Naky/f5x /VNtS/sfd1662gwLEhUcSbCmM36v91uGVD aMG2vPum7/ 03vHiat4zzYPNjQWCPn /fv37dvX0dER94oMZlZy3TrT1P78y3u2b9tamG/xDbfu/f0f/7bvz / 8997f/6zo03tdUf /sZvfvvKL9/ongwgE/rttwDeOg06 i73y0 sNZ2 2JmWlj4xeKOx8UL38Li9//pb77zd0j5C87xvxtbdO3Dxyxpp2Zby/AyUBWqADUK fv16lFt3d3dXVlbGeWAkmcAb0gyR/sGRkN Hl2NuttVO0PkvP1Nxtrm/bGP uf e PTwEcOqrS8/9yTP3u/JX29KUMvY1Xzm5oxQuSb37MmT0wF5WenG1aXLH9 4Zri3o6enu/vmcECUMose e7W0qaGRo979oa1dcThU3begm2evw3 jKz3wMBAXn4ewG/YsOFO8JT423REZ1y/Mrfm0KfWYbtR4Mue EGhPNrYPv78i8 xAY/E5v74padtN4fScoo2bSnXM4uQ UDEorW rmT3T15/acf5y1ctubmVO3frHcOTXNEPn316U WWXTs3hxw2eyDtqad27Nj9zKaVFm8k59ndWxO dgaA7e3teNctQTUDzmGWsL2jcxXrgSHFReFlSDkCOSjeGcK/NKo3QqIM1Q4tG4YLFyaGcbF8S6Ir4eghaKMYDpKUZxhJwvCIt0eWpNIDY1KUHEmxqsd3NwQRDh4 8uGfPngQaD4BjMcddjMINxH5JKA0OKhq AChqeRgav BCcnbxMCs4yf0xv oD1VdQlRheREL4WfFvojgRk14IcywQYgTvBMMWOFLJmRobW9It qILXVdXt27dOiwVFfJCSuDuHAjRcCyjOp24irzee08tMqdhlHQKVsTX02iL3AtBhOqqqp 8sr/ACSiwTxI4/ZRAAAAAElFTkSuQmCC

Zack Barresse
04-27-2016, 11:49 AM
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. ;)