Help!
Whenever I use the @ on my worksheet without following it with a space, it creates a hyperlink. How can I turn this auto function off?
I also have a 500 item column of hyperlinks I want to convert to text. ???
(Windows XP, Excel 2000)
Thank you in advance! DUMBO 
Turn off auto hyperlink on worksheet? [SOLVED]
-
-
Hi Dumbo
Welcome to the board
The easiest way I know of is to preceded the email address with a single apostrophe, e.g
With Excel 2002 (I think 2000 is the same), you can turn this off permanently via Tools>Auto correct options-Autoformat as you type
-
Hi Dumbo,
2 subs for deleting hyperlinks:
Sub Delete_Column_Hypers()
Columns("A:Z").Hyperlinks.Delete
End SubSub Delete_Sheet_Hypers()
ActiveSheet.Hyperlinks.Delete
End Sub
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!