To save time, lets just assume the Microsoft Trust Prompt after opening a hyperlink will open regardless of trust center settings. I tried automating the prompt with something simple like:

Application.Wait (Now + TimeValue("00:00:05"))
Application.SendKeys ("{LEFT}")
Application.SendKeys ("{ENTER}")

After trying it I realized in order for that to work I would have to be running 2 threads, which Microsoft Excel does not natively allow (I cannot use DLLs or modify the program). Has anyone found a way to automate the trust prompt, or even found a way to refer to it with code (which I know is against the whole point of the prompt, but still...)? I would need a solution with "Native" Microsoft Excel.

Thank You!