info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Recover formatting
0 views
Skip to first unread message
Huw
Dec 15, 2002, 10:19:03 PM12/15/02
to
A spreadsheet containing links to jpegs has lost the formatting of the
links, so they now appear the same as non-linked cells, but continue to
function correctly. i.e. on hover the cursor turns to a pointy fingered
hand, and the browser opens the image if the cell is clicked.
links, so they now appear the same as non-linked cells, but continue to
function correctly. i.e. on hover the cursor turns to a pointy fingered
hand, and the browser opens the image if the cell is clicked.
I think this was caused by use of the 'AutoFormat - None' command whilst the
whole sheet was selected.
Is there a way to return all the links to blue / purple underlined?
TIA
Huw
Bill Manville
Dec 16, 2002, 3:01:16 AM12/16/02
to
Huw wrote:
> Is there a way to return all the links to blue / purple underlined?
>
Run this macro:> Is there a way to return all the links to blue / purple underlined?
>
Sub RestoreHyperlinks()
Dim H As Hyperlink
For Each H In ActiveSheet.Hyperlinks
H.Range.Style = "Hyperlink"
Next
End Sub
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Huw
Dec 16, 2002, 5:45:10 PM12/16/02
to
Perfect. Thanks very much.
"Bill Manville" <Bill-M...@msn.com> wrote in message
news:VA.00000f2...@msn.com...
0 new messages