Hide Title Bar of Internet Explorer from excel VBA
Hello All,
Need help to hide/disable the internet explorer title bar when opening an IE from excel VBA code.
I am opening a website from excel code, i am trying to hide/disable the internet explorer title bar(Ribbon which appears on the top left, screen short attached to the query) after the page is loaded.
I couldn't find the exact attribute which can help me in hide/disabling the title bar of the internet explorer.
Below is the piece of code i am using.
Sub Button1_Click()
Dim i As Long
Dim URL As String
Dim IE As Object
Dim objElement As Object
Dim objCollection As Object
Set IE = CreateObject("InternetExplorer.Application")
URL = "https://www.google.com/"
IE.Visible = True
IE.MenuBar = 0
IE.AddressBar = 0
IE.StatusBar = 0
IE.Toolbar = 0
IE.Navigate URL
Set IE = Nothing
Set objElement = Nothing
Set objCollection = Nothing
End Sub