Excel VBA: WebBrowser Control Is Not Working In Windows 10

[kashif.special2005]

Hi,

I have a webbrowser control in a form, where a html files contents shows in it, it is working fine in windows 7, but I don't know it is not working in Windows 10.

Code Not Working:- below code fires on click event of a button

If Sheet1.CheckBoxes("chkMailBody").Value = 1 Then
    
    
    MailBody.WebBrowser1.Navigate "G:\Request.html"
    MailBody.Show
    
    'MailBody.WebBrowser1.Visible = True
    
End If

Code Working:- When I am running below code separately (On Run Forms Initialize Event Not From Button) Webbrowser is working fine and the content is showing in the webbrowser.

Private Sub UserForm_Initialize()
    Me.WebBrowser1.Navigate2 "G:\Request.html"
End Sub

Please help me to resolve this problem.

Thanks
Kashif

 

[kashif.special2005]

Hi All,

Somehow I found the solution in Google and below is the steps to resolve this issue.

Go to Outlook Options > General. Then under "User Interface Options" for the setting "When using multiple displays" select the option "Optimize for compatibility"


Then restart outlook. The same option should be available in Excel too. Try and see if it works. It worked for me. I hope it works for you too.


Thanks
Kashif