Member Avatar for deni_bg

Hello people!
I have a question. I use windows xp operating system and ms office professional 2007.
When I want to import a tif file in Excel 2007 as a hyperlink from Hyperlink button, I succed import the tif file, but when I double click on the link it occurs this message:

Opening C:\Documents and Settings\UserName\Desctop\mypic.tif

Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source.
Would you like to continue.

Well, I would like to know how I can to open some tif file that is importing in excel programm as a hyperlink without see this message every time. Can anybody tell me?

Thank you very much!

  • 2 Contributors
  • 4 Replies
  • 288 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by rubberman

Dani AI

Generated

Short answer and what to try (for , running Windows XP + Office 2007).

The warning you see is an Office/Windows safety dialog (not a macro warning). Office shows a hyperlink warning and, for TIFF/MDI files, Windows/HLINK.dll can show a second “Some files can contain viruses…” dialog. Changing macro security alone will not remove those messages. Microsoft documents the registry switch to suppress Office hyperlink warnings and also explains the TIFF/HLINK special case. Microsoft: Enable or disable hyperlink warning messages in Office applications. (support.microsoft.com)

If you want to keep hyperlinks but stop the Office-level prompt in Office 2007, add the registry DWORD:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Security\DisableHyperlinkWarning = 1
(then close and reopen Excel). That turns off the Office warning for hyperlinks; use the 12.0 path for Office 2007. See Microsoft’s steps. (support.microsoft.com)

If the TIFF dialog still appears (the HLINK.dll message), use one of the two methods Microsoft recommends for Windows XP:

  • Method 1 (Windows XP): Explorer -> Tools -> Folder Options -> File Types -> find the TIF/TIFF entry -> Advanced -> clear “Confirm open after download”.
  • Method 2 (all Windows): under HKEY_CLASSES_ROOT\<ProgID> rename EditFlags to OldEditFlags and create a new EditFlags DWORD with hexadecimal value 10000 to suppress the HLINK warning. Follow Microsoft’s exact steps and pick the correct ProgID for .tif files. (support.microsoft.com)

Important cautions: editing the registry reduces protections — back up the registry or create a restore point before changing anything, and only disable warnings for trusted files. Microsoft’s guidance on backing up the registry is here: How to back up and restore the registry in Windows. (support.microsoft.com)

As noted, embedding the image in the workbook (instead of a hyperlink) avoids these warnings entirely at the cost of larger workbook size and losing an externally editable file.

Recommended Answers

All 4 Replies

Member Avatar for rubberman

You probably need to change your Excel security settings to a less restrictive mode. I only have Office 2003 and there is nothing I can find in Excel for hyperlink security, but there may be for 2007. In any case, I get the same dialog when I embed a hyperlink. If you just want the picture, then you may want to embed it directly into the spreadsheet instead of hyperlinking it.

Member Avatar for deni_bg

no, I want to import the picture as a hyperlink, but I don't want to see this warnings message again

Member Avatar for deni_bg

I changed the macros settings in excel, but excel displays the message again

Member Avatar for rubberman

Well, I think that you may be SOL unless you embed the graphic directly and not as a hyperlink.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.