Dave
Fri Feb 09 10:47:53 CST 2007
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
> > <petersod@verizonXSPAM.net> 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