Cell formatting

I do not want the cell format to change when I add a hyperlink. Presently,
the font, colour and underscore changes whenever I add a hyperlink. As I
shall be adding links over a period of time, I do not wish to keep changing
the formatting all the time. Is there a way of avoiding having to do this?
(like how do I change the default for hyperlinks?)

Rita

In later versions you can go to ToolsAuto correct options... and select the
'autoformat as you type' tab, un-checking the 'internet and network paths
with hyperlinks' entry

Other versions, hitting Ctrl+Z straight after entry (Undo). It will undo the
formatting but not the entry. Pain, but that's about all you can do

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"rita" wrote in message
...
I do not want the cell format to change when I add a hyperlink. Presently,
the font, colour and underscore changes whenever I add a hyperlink. As I
shall be adding links over a period of time, I do not wish to keep
changing
the formatting all the time. Is there a way of avoiding having to do this?
(like how do I change the default for hyperlinks?)

Ctrl+z will undo formatting and hyperlink in Excel 2000.
I don't think it would act differently in other versions.

Since the hyperlink was wanted but not the formatting the following
would work in Excel 2000. Insert the following code for the sheet you want it
applied to by right click on sheet name, view code, insert code.

Private Sub Worksheet_Change(ByVal Target As Range)
'-- hyperlink color when change is made
With Target.Font
.ColorIndex = xlAutomatic
End With
End Sub

If you want to drive people crazy (most of all yourself), you could change
the style it would apply to the entire workbook.
Format, style, stylename: hyperlink, uncheck color
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nick Hodge" wrote in message ...
Rita

In later versions you can go to ToolsAuto correct options... and select the
'autoformat as you type' tab, un-checking the 'internet and network paths
with hyperlinks' entry

Other versions, hitting Ctrl+Z straight after entry (Undo). It will undo the
formatting but not the entry. Pain, but that's about all you can do

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"rita" wrote in message
...
I do not want the cell format to change when I add a hyperlink. Presently,
the font, colour and underscore changes whenever I add a hyperlink. As I
shall be adding links over a period of time, I do not wish to keep
changing
the formatting all the time. Is there a way of avoiding having to do this?
(like how do I change the default for hyperlinks?)