I don't get a chance to read this newsgroup all that often, so if you
have a hint, please email me directly at chri...@fuller.edu Thanks a
lot!
Chris
Regards,
Tom Ogilvy
MVP Excel
Chris Low <chri...@fuller.edu> wrote in message
news:390E1CAD...@fuller.edu...
----- Posted by John Walkenbach (MVP) -----
----- Visit The Spreadsheet Page -----
----- http://www.j-walk.com/ss -----
Tom Ogilvy <twog...@email.msn.com> wrote in message
news:OqaSIv8s$GA.259@cppssbbsa05...
If you don't want to bother hitting the Select ALL or never
wish to be selective:
Sub RemoveHyperlinks()
Cells.Hyperlinks.Delete
End Sub
Adding to John's and Tom's comments:
I usually use ctrl+z (undo) to remove the ones I don't want
immediately after typing. I seldom think ahead by typing
the single quote in font.
For those who want some more information on
see http://www.geocities.com/davemcritchie/excel/buildtoc.htm
Since this is the misc group those needing help installing a macro
see http://www.geocities.com/davemcritchie/excel/formula.htm
HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
http://support.microsoft.com/support/kb/articles/Q233/0/73.ASP
Q233073 -- XL2000: How to Prevent the Automatic Creation of Hyperlinks
Personally I like hyperlinks and will remove the ones I don't want as
previously described.