Consulting

Results 1 to 3 of 3

Thread: Hide Title Bar of Internet Explorer from excel VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question 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
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •