Web Query Macro - Mixed content prompt prevents script from loading data

I created a macro that will load data from a web page, however I get a
message that says the data cannot be loaded. When I manually use the New Web
Query dialog box, I have to click through several prompt boxes that ask
whether or not to allow both secure and nonsecure on the page. After that, I
am able to select the table that I want to import into Excel. In Internet
explorer, I have changed the security settings to enable for the allow mixed
content (it was prompt) and checked off 'warn if changing between secure and
nonsecure sights'. After doing this, when I load up IE and go to the web
page, I do not get the security information prompt anymore however when I use
the manual New Web Query dialog boxes in Excel, it still comes up. Also, my
query is still not coming up. Is there a way to programmatically set yes or
change config values in Excel to avoid this prompt?

Thanks in Advance!