Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    2 Hyperlink questions! (Excel 2003)

    1. How can I prevent the warning message from showing each time I click a hyperlink.
    (See attachment)

    2. Why does a hyperlink open windows explorer when the file (or directory) to hyperlink to starts with a "#" (hash sign).
    E.g. - Click on a hyperlink whose address is C:My Documents#Test.txt or C:#My DocumentsTest.txt.
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2 Hyperlink questions! (Excel 2003)

    1. See MSKB article How to disable hyperlink warning messages in Office 2003. It nvolves editing the registry, so be careful.

    2. The # character is used internally in the stored hyperlink to separate the display name, the hyperlink address and the subaddress, therefore a # in the path/filename is seen as such a separator. The obvious solution is not to use # characters in the name of folders and files.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Hyperlink questions! (Excel 2003)

    Thankx Hans,
    I don't usually use # signs in my path names... , but I have come across it recently, and thought I'd just post is as a query to clear it up. I was not sure why it did it in the first place.
    Thanks for the link too. I will follow up on this for my PC at home, as I'm not keen on the warning that prompts up each time I click a link!
    Regards,
    Rudi

Posting Permissions

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