How to disable hyperlink warning messages?
Hello friends,
I used hyperlink connection to open few link to pull the data.
Warning message appears like: some files can contain viruses or otherwise be harmful to your computer.... with OK & Cancel button.
Please anyone can help how to disable this message.
Run the hyperlink in loop, warning message shown for continue to loop end. Manual click OK there after go to the next.
if possible macro code to click OK button or some other method.
Is the warning message generated by OS or by Excel?
You could use
Application.DisplayAlerts = False
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by DJohnny; 08-06-2014 at 06:29 AM.
thanks DJohnny,
i used Application.DisplayAlerts = False, still warning msg came.
Can you put the code or the file to preview the code?
Here is the code:
Formula:
Please Login or Register to view this content.
Please try the following before your code, then the second code after to switch back on:
Please Login or Register to view this content.Edit: I usually use xlCalculationAutomatic twice after, as there have been occasions where the switch hasn't worked when it was in there once. I think the EnableEvents is what will fix your issue, so you could just try that :-)Please Login or Register to view this content.
thanks Jennasis .
I used your codes, but still shown the warning msg.
the following works for me:
I have the full path of the MSG file I want to open
I add this to my macrob declaration:
then I add this inside my macro:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AliGW; 03-10-2019 at 04:01 AM.
Welcome to the forum!
The thread to which you have posted is well over four years old - did you realise?
The OP was not asking how to display an error message, rather how to suppress one.
Administrative Note
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks