Thanks all, much appreciate the help.
"David McRitchie" wrote:
Hi Terry, (for the macro approach, you asked for)
In Excel 2002 and above:
Tools, AutoCorrect Options, AutoFormat As You Type (tab
[x] Internet and network paths with hyperlinks.
(Would only affect individual cells as typed)
If you reenter the value with F2 then Enter for each it will
become a hyperlink.
So it does!
And I found that if I typed the link in directly (e.g.
'www.microsoft.com') then it became a proper link, yet if I pasted it
from my text editor or whatever, it remained mere text.
But for a lot of cells you would use a macro...
macro approach:
Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
http://www.mvps.org/dmcritchie/excel...MakeHyperlinks
The first of those worked fine.
To install a macro that you would get from the above
http://www.mvps.org/dmcritchie/excel....htm#havemacro
Very glad you included that, David, as it's been so long that I'd
forgotten how non-intuitive the VBA Editor window was! To me anyway.
Faced with this in the Project pane
---------
VBAProject (Photo Upload Index.xls)
-Microsoft Excel Objects
Sheet1 (Sorted by date)
ThisWorkbook
-Modules
Module1
---------
....it was not at all obvious to me either which one of those three (if
any) was already selected, nor which one I should select!
More information on Hyperlinks in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Terry Pinnell" wrote...
I have a set of standard URLs in my text editor, like
http://www.xyz.com
http://www.abc.com/123.htm
etc
I paste them into a new Excel 2000 column. But how can I quickly get
them all to become proper links, so that a click will open that
address in my browser please?