 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Hyperlinks
Is there a way in excel to turn off the hyperlink feature for an entire column of data? I have a column of email addresses, and I don't want any of them to be an active hyperlink. I can remove the hyperlink individually, but have not been able to find a way to do it for the entire column of data. Thanks! Candace A small macro will remove any existing hyperlinks. Sub Delete_HLinks() For Each cel In Selection cel.Hyperlinks.Delete Next cel End Sub To prevent future hyperlinks for the entire sheet go to Tools>Autocorrect Options>AutoFormat as you type. Un-select "Replace as you type" for internet addresses etc. Gord Dibben MS Excel MVP >Is there a way in excel to turn off the hyperlink feature for an entire >column of data? I have a column of email addresses, and I don't want any of >them to be an active hyperlink. I can remove the hyperlink individually, >but have not been able to find a way to do it for the entire column of data. > >Thanks! And I think you can remove all the hyperlinks in one fell swoop <bg>. Sub Delete_HLinks() Selection.Hyperlinks.Delete End Sub > Candace > [quoted text clipped - 19 lines] > > > >Thanks!  SignatureDave Peterson Thanks Dave. Always a faster way. Gord >And I think you can remove all the hyperlinks in one fell swoop <bg>. > [quoted text clipped - 25 lines] >> > >> >Thanks! Gord Dibben MS Excel MVP YOU ARE THE BEST! I've been struggling with this for a while. Just like Candace, I needed to remove several pastes hyperlinks, but I do not want to turn them off completely, So Thank You Very Much Ruth No Reply Needed > And I think you can remove all the hyperlinks in one fell swoop <bg>. > [quoted text clipped - 25 lines] > > > > > >Thanks! Glad you got it working the way you want. > YOU ARE THE BEST! > [quoted text clipped - 38 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.