Dear Mr. Excel fans,
I have an extensive VBA code which requests a password to execute. This password can be obtained on an internal company web page (behind VPN). If the user fails the password, then I open this page up automatically -- if the user is authorized to access VPN, then they are OK to run my macro. However, if the user is not connected to VPN, or properly logged into the company web page, then the address I am trying to go to is not valid.
If you try to go to an invalid address with FollowHyperlink, the macro seems to hang for a number of minutes.
Is there a way to execute this line within the macro as a background process, or to only wait about 4 seconds before moving on in the code? Should I put this line into a form and run it as non modal?
I don't want to post the actual link for obvious security reasons,but the code (sans address) looks like:
I have an extensive VBA code which requests a password to execute. This password can be obtained on an internal company web page (behind VPN). If the user fails the password, then I open this page up automatically -- if the user is authorized to access VPN, then they are OK to run my macro. However, if the user is not connected to VPN, or properly logged into the company web page, then the address I am trying to go to is not valid.
If you try to go to an invalid address with FollowHyperlink, the macro seems to hang for a number of minutes.
Is there a way to execute this line within the macro as a background process, or to only wait about 4 seconds before moving on in the code? Should I put this line into a form and run it as non modal?
I don't want to post the actual link for obvious security reasons,but the code (sans address) looks like:
VBA Code:
ActiveWorkbook.FollowHyperlink "https://[invalid address here]"
