Is it possible to suppress hyperlink warning messsages?

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.
 
C

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 ...
 
J

Jim Rech

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.
 
C

CRS

Magic Jim. That works perfectly. Very many thanks.

CRS.

________________________________________________________________________
Original message from Jim Rech follows ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top