Overactive hyperlinks

G

Guest

I am using an excel spreadsheet for my personal address book. One
column of cells contains a web address or an email address.

Once in a while I'll accidentally click on one of the web addresses or
email addresses. This, as expected, starts up either my browser or
email program. Is it possible to disable the feature that has excel
start my browser or email program? I would like to disable this
feature on a temporary basis if possible.

Dave
 
D

Dave Peterson

You could remove the hyperlink completely.

But if you wanted the hyperlink sometimes and didn't want it other times, I
think you're at a loss.
 
G

Guest

Would it be possible to enter the hyperlink in the cell as a comment
of some sort? If I ever needed to start my browser, I could always
copy & paste the address into my browser.
 
B

Beege

No-Spam at nordquist dot us said:
Would it be possible to enter the hyperlink in the cell as a comment
of some sort? If I ever needed to start my browser, I could always
copy & paste the address into my browser.
Click to expand...

Dave,

Autocorrect Options has a tab for "Correct as you type" that turns typed
addresses and URLs as hyperlinks. Uncheck this, and then right click -
remove hyperlink - on each address and URL.

HTH

Beege
 
D

Dave Peterson

You could use a macro that did the work:

Option Explicit
Sub testme()
Dim myHyperlink As Hyperlink
Dim wks As Worksheet
Set wks = Worksheets("sheet1")

For Each myHyperlink In wks.Hyperlinks
With myHyperlink
If .Parent.Comment Is Nothing Then
'do nothing
Else
.Parent.Comment.Delete
End If
.Parent.AddComment Text:=.Address
'.Delete
End With
Next myHyperlink
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
R

Ron Coderre

Try something like this example:

Turn off automatic hyperlinks (in the autocorrect options)

Enter your URL list in B2:B20

A2: =HYPERLINK(B2,B2)
Copy that formula down through A20

Now.....B2:B20 are just text
BUT....Clicking on A2:A20 engages the browser/email app

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Top