Overactive hyperlinks

[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

 

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

 

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

 

[Dave Peterson]

Sure. It sounds like more work than it's worth, but you could do that.

 

[Beege]

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.

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

 

[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

 

[Guest]

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