Excel 2000 mailto hyperlink

[WindowWizard]

How do you disable hyperlinks from being created (globally) when entering addresses in cells? In Office XP there is an option to turn this off, but where is that option in Office 2000?

 

[mbarron]

I couldn't find a way to do a "universal" removal of hyerlinks.

Here's a quick and nasty macro that will remove the hyperlink in selected cells. I'm fairly new in macros, but as far as I can tell it won't do anything to the cells except remove the hyperlink.


Sub hype()
'
'
Dim remhyp As Range

For Each remhyp In Selection
Selection.Hyperlinks.Delete
Next
End Sub Mike

Before: After

 

[WindowWizard]

Thanks, but macros are purposely disabled on many of our systems. However, it is comforting to know that I'm not the only one who can't find a way.

 

[mbarron]

The best way (non-macro) I can think of is by removing the hyperlink from one (rt click/ Hyperlink> Remove hyperlink), then copying the cell and then doing a Paste Special... Formats. Mike

Before: After