Consulting

Results 1 to 6 of 6

Thread: How to prevent Hyperlink virus warning dialog

  1. #1
    VBAX Regular
    Joined
    Feb 2008
    Posts
    8
    Location

    How to prevent Hyperlink virus warning dialog

    Is is possible to stop or prevent a hyperlinked ascii file from the virus warning dialog box from popping up? What is wierd is in the Excel VBA file I have created, on my own computer, I can click on the hyperlink and it fuctions with out the warning, but if I go to a different computer and run the same Excel VBA file I get that stupid warning. If I click "ok" the file will then appear in "Word", but if I click "cancel" then I get debug error in my VBA code.

    Mark

  2. #2
    You could try putting your code between the display alerts!
    [VBA]
    Application.DisplayAlerts = False
    'YOUR CODE HERE
    Application.DisplayAlerts = True
    [/VBA]
    Regards,
    BG.

  3. #3
    VBAX Regular
    Joined
    Feb 2008
    Posts
    8
    Location
    No, that did not work. Still have the same results.

  4. #4
    VBAX Regular
    Joined
    Feb 2008
    Posts
    8
    Location
    There has been a weird change. I can now click on the hyperlink in the Excel range and it will bust off Word and show the ascii document, but when it runs through the VBA, I get prompted with dialog box " some files contain viruses, bla,bla, would you like to open this file". Any other clues would help.

  5. #5
    Well to disable those messages you need to hack around in your registry but i wouldnt recommend it, that said here is MS supports view on how to do it Disable Hyperlink Warning
    Regards,
    BG.

  6. #6
    VBAX Regular
    Joined
    Feb 2008
    Posts
    8
    Location
    That makes sense. I guess I will have to write a VB stand alone and use the Excel SS as a reference. Thanks for finding that info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •