View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

hi katnip,
If you do not have Excel 2002 or later you will have to do
something else. Such as deleting the hyperlinks afterwards with
a macro. You can run a macro to remove hyerlinks from a
selection or you could have an event macro delete the hyperlinks
as soon as they are entered. You can try using Ctrl+Z immediately
after a hyperlink is generated but that will interfere with normal typing
and you will miss some.

Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
ToolsAutoCorrect OptionsAutoformat as you typeReplace as you type.
Uncheck "Internet and network paths with hyperlinks"


On Sat, 5 Feb 2005 05:57:01 -0800, "kattnip"
I would like to setup the sheets without this hyperlink