How to disable mailto link under Excel 2000 ?

H

Help~

When there is a "@" character in cell, it will turn into mailto link directly.
If I remove the link and edit the cell, the link appears again.
All the solution I can found are for Excel 2002 and later.
How to disable mailto link under Excel 2000 ?
 
S

Simon Lloyd

SImply put this code in the worksheet code module that you are workin
with
Code
-------------------
Private Sub Worksheet_Change(ByVal Target As Range
Me.Hyperlinks.Delet
End Su
-------------------

Help~;256189 said:
When there is a "@" character in cell, it will turn into mailto lin
directly
If I remove the link and edit the cell, the link appears again
All the solution I can found are for Excel 2002 and later
How to disable mailto link under Excel 2000

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top