Overactive hyperlinks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

No-Spam at nordquist.us - 09 Feb 2007 15:52 GMT

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

Reply to this Message

Dave Peterson - 09 Feb 2007 16:04 GMT

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.

No-Spam, at, nordquist.us wrote:

> I am using an excel spreadsheet for my personal address book. One
> column of cells contains a web address or an email address.
[quoted text clipped - 6 lines]
>
> Dave

Signature

Dave Peterson

Reply to this Message

No-Spam at nordquist dot us - 09 Feb 2007 16:28 GMT

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.

>You could remove the hyperlink completely.
>
[quoted text clipped - 13 lines]
>>
>> Dave

Reply to this Message

Dave Peterson - 09 Feb 2007 16:43 GMT

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

No-Spam, at, nordquist, dot, us wrote:

> 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
[quoted text clipped - 17 lines]
> >>
> >> Dave

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 09 Feb 2007 16:47 GMT

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

> Sure. It sounds like more work than it's worth, but you could do that.
>
[quoted text clipped - 25 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message

Beege - 09 Feb 2007 16:44 GMT

> 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
[quoted text clipped - 16 lines]
>>>
>>> Dave

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

Reply to this Message

Ron Coderre - 09 Feb 2007 17:19 GMT

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

> I am using an excel spreadsheet for my personal address book. One
> column of cells contains a web address or an email address.
[quoted text clipped - 6 lines]
>
> Dave

Reply to this Message