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

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

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.

On Fri, 09 Feb 2007 10:04:04 -0600, Dave Peterson
<(E-Mail Removed)> wrote:

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

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
> copy & paste the address into my browser.
>
> On Fri, 09 Feb 2007 10:04:04 -0600, Dave Peterson
> <(E-Mail Removed)> wrote:
>
> >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.
> >>
> >> 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

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
> copy & paste the address into my browser.
>
> On Fri, 09 Feb 2007 10:04:04 -0600, Dave Peterson
> <(E-Mail Removed)> wrote:
>
>> 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.
>>>
>>> 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,

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

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

Dave Peterson wrote:
>
> 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
> > copy & paste the address into my browser.
> >
> > On Fri, 09 Feb 2007 10:04:04 -0600, Dave Peterson
> > <(E-Mail Removed)> wrote:
> >
> > >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.
> > >>
> > >> 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

--

Dave Peterson

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


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