Is it possible to suppress hyperlink warning messsages?

  • Thread starter Thread starter CRS
  • Start date Start date
C

CRS

Is there any way that I can suppress the warning message ("Hyperlinks
can be harmful to your computer and data ... etc, etc") when I click on
a hyperlink in an Excel spreadsheet cell?

Any advice appreciated. Many thanks.

CRS.
 
Just to clarify - the hyperlinks in questions are links to small jpg
files which are held locally on my computer.

For example, a cell would typically contain ...

file://c:\PIX\Pic01.jpg

Thanks again.

CRS.

________________________________________________________________________
Original message from CRS follows ...
 
I find this message only appears for the new Excel 2003. So if that's the
version you have you can block the warning with a registry entry.

From Start->Run enter "Regedit" without quotes and press Enter.

Navigate to this key in the left panel:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Security

If you do not have a Security key under Common (I didn't) create it by
right-clicking on Common and picking New and Key. Give it the name
Security.

After creating Security, select it in the left panel and in the empty right
panel right-click anywhere and select New and Dword value. Give it the
name: DisableHyperlinkWarning

and press Enter. This entry will have the value 0. Double-click it and
change the value to 1 and press Enter.

You can close Regedit. And Excel 2003 should not give the warning any
more.
 
Magic Jim. That works perfectly. Very many thanks.

CRS.

________________________________________________________________________
Original message from Jim Rech follows ...
 
Back
Top