+ Reply to Thread
Results 1 to 14 of 14

alert opening hyperlink

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    alert opening hyperlink

    Hi everyone.
    In a workbook I have various hypertext links to JPG and TIF images.
    Because if I choose a TIF image is displayed a warning

    file opening .....
    some files may contain visus or damage .....
    make sure of the source of the files.
    open the file?

    and not for a JPG image?
    The alert also appears for PDF files.
    Is it possible to disable these warnings without changing the regedit?
    max

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: alert opening hyperlink

    Have you tried to set the display warnings to false?
    On workbookOpen
    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: alert opening hyperlink

    Quote Originally Posted by Keebellah View Post
    On workbookOpen
    Please Login or Register  to view this content.
    It is actually
    Please Login or Register  to view this content.
    Which might be better done on Follow Hyperlink (if it will work) rather than Workbook Open, then set back to true after the link has been opened in order to prevent the suppression of other alerts which might still be required.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: alert opening hyperlink

    My mistake, just typed it in without thinking, Alerts was the word I was looking for

  5. #5
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: alert opening hyperlink

    Quote Originally Posted by Keebellah View Post
    just typed it in without thinking
    did you learn how to do that from me?

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: alert opening hyperlink

    After 20+ years of coding and my age ... you forget things was just too quick to type and ... well, you pointed me back in the right direction

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: alert opening hyperlink

    Hi
    Please Login or Register  to view this content.
    nothing changes
    max
    Attached Files Attached Files

  8. #8
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: alert opening hyperlink

    I no longer have the macro security warning with


    Please Login or Register  to view this content.
    how to activate it?

  9. #9
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: alert opening hyperlink

    In your Excel Optiones, Trustcenter settings

  10. #10
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: alert opening hyperlink

    O.k. restored warning but this does not work
    Please Login or Register  to view this content.
    with tif warning continues to appear

  11. #11
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: alert opening hyperlink

    Try reading post 3

  12. #12
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: alert opening hyperlink

    Hi jason.b75

    Please Login or Register  to view this content.

    I tried but it doesn't work

  13. #13
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: alert opening hyperlink

    In that case, the answer to your question
    Quote Originally Posted by max_max View Post
    Is it possible to disable these warnings without changing the regedit?
    is no!

  14. #14
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: alert opening hyperlink

    I think this warning comes from the internet explorer (browser) and nothing to do with Excel
    Last edited by Keebellah; 07-14-2019 at 03:21 PM. Reason: info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Upon opening file i get an excel alert message. How to prevent this?
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2014, 09:11 AM
  2. Replies: 0
    Last Post: 10-10-2013, 05:14 AM
  3. [SOLVED] Alert when opening a workbook
    By mrr2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2013, 02:36 PM
  4. How to avoid 're-open' alert while opening file
    By excelquestioner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2007, 02:29 PM
  5. diabling the macro alert in opening files
    By R.VENKATARAMAN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2005, 09:05 AM
  6. Hyperlink not opening
    By nikhilkaran in forum Excel General
    Replies: 0
    Last Post: 06-14-2005, 09:05 AM
  7. Prevent "Opening..." alert when opening from VBA
    By Steven Wallace in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2005, 11:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1