Datasheet

Disabling Hyperlink Warnings
As you probably know, Excel lets you insert a hyperlink into a cell. A hyperlink can acti-
vate a different sheet or a different workbook, or it can execute an external program. For
example, if a cell contains a hyperlink to an MP3 music file, clicking the hyperlink plays
the song on the default music player.
Hyperlinks are great — until you start using them. Unless the hyperlink goes to a location
in the same workbook, you see the warning message shown in Figure 26-1. If you click 20
hyperlinks, you see the message 20 times. You even see the message if the hyperlink
points to an Excel workbook that’s in a trusted location. And there is no direct way to turn
it off!
Figure 26-1: Clicking a hyperlink may display this message.
You can avoid seeing this annoying message — but you need to make a modification to the
Windows Registry:
1. Close Excel.
2. Click the Windows Start button, and then choose Run.
3. In the Open dialog box, type regedit and then click OK. This command launches the
Registry Editor.
4. In the Registry Editor, locate the following Registry subkey and click it:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common
5. Choose Edit New Key.
6. Type Security, and then press Enter to name the key.
7. With the Security key selected, choose Edit New DWORD Value.
8. Type DisableHyperlinkWarning, and then press Enter to name the entry.
9. Double-click the DisableHyperlinkWarning entry to display the Edit DWORD Value
dialog box.
Tip 26: Disabling Hyperlink Warnings
66
04_137666 ch01.qxp 5/22/07 7:31 PM Page 66