Summation creates Mailto hyperlink

[Paul Clemmons]

Ok, here is one I haven't seen before. I have a customer that has excel
spreadsheets ranging from 97 to 2003 and she is using Office 2003.
Occasionally, when she is doing a summation on a column, the result is a
hyperlink that when you inspect it has "mailto:=" and then the formula of
the summation. Of course if you click on the hyperlink, it opens up a new
email with the formula in the TO: block. I am just wondering if there is a
way to block the creation of hyperlinks in the program itself (sheet by
sheet would take too long to accomplish) or what is causing this to happen.

Paul Clemmons
PC Networks
http://www.pcnetworkswa.com

 

[Don Guillett]

Look under tools>auto correct options>correct as you type>uncheck

Maybe this will help to get rid of them ALL at once

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub