Very easy. If you enter:

http://www.cnn.com

in a cell, Excel will generate a "click-able" hyper link if you have enabled
this with:

Tools Options Spelling AutoCorrect Autoformat as you type
and check the hyperlink box.

You don't need to change this option.

Enter the URL with a single quote (apostrophe) in front:

'http://www.cnn.con

and then enter this Event macro in worksheet code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveWorkbook.FollowHyperlink Address:=Target.Value
End Sub


so a single click will do nothing, but double-click and away you go!


REMEMBER: worksheet code.
--
Gary's Student
gsnu200709


"AucklandAssault" wrote:

I have a number of hyperlink in my spreadsheet that links to pdf files on the
net. Users often select these accidently when navigating the spreadsheet. I
want to change my spreadsheet so that it requires users to double-click for
the hyperlinks to work. How do I do this?