How to stop opening outlook in excel
How to stop opening outlook in excel when clicking into a cell that contains
an email address. |
How to stop opening outlook in excel
Well, you can stop Excel from automatically converting email addresses
to hyperlinks. Tools Options Spelling click 'AutoCorrect Options AutoFormat As You Type uncheck 'Internet and network paths with hyperlinks' --JP On Sep 23, 3:10*pm, bill s <bill wrote: How to stop opening outlook in excel when clicking into a cell that contains an email address. |
How to stop opening outlook in excel
If you want to delete the hyperlinks...........not the contents, run this
macro. Sub Delete_Hyperlinks() Dim Cell As Range For Each Cell In Intersect(Selection, _ Selection.SpecialCells(xlConstants, xlTextValues)) Cell.Hyperlinks.Delete Next Cell End Sub To prevent future hyperlinking see JP's reply. Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 12:10:02 -0700, bill s <bill wrote: How to stop opening outlook in excel when clicking into a cell that contains an email address. |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com