I have some code that creates an html page on my workstation and then launches the html in the default browser. Each time it does this, an ActiveX warning appears with the title "Web Browser" with the message Active Content might harm your computer....are you sure you want to allow Active Content to access your computer?"
The problem with the message is that the horse is already out of the barn, and the message is only a nuisance. The webpage is already launched in Chrome or Firefox so this message isn't blocking anything anyway. Sometimes it ends up appearing behind the active window and I cannot select the option to close the message (I have my workstation set to change focus to the window my mouse is over). I know I can use keyboard shortcuts to switch back to this message but many times Excel does not display the message box properly essentially hanging my Excel session and I end up having to terminate the Excel session through Task Manager.
The alert appears to only refer to Internet Explorer anyway and since I'm using Chrome the solution it offers to prevent the message is meaningless and there's no ActiveX being run anyway. The link in the message points to: https://support.microsoft.com/en-us/...0_lockdownzone
How can I eliminate this message when executing this code since the code is carefully selecting the html I am running?
The code:
ActiveWorkbook.FollowHyperlink _
Address:=strFNAME, _
NewWindow:=True
Bookmarks