hyper links

[Eric Roberts]

I'm having an issue where someone received an excel file
with cells being formatted to "mail to" when they are
clicked on. Is there a way to turn this off on the whole
sheet not just by right clicking the cells affected and
doing it that way? Also, the person that received the
formatted document now is having an issue where excel is
formatting cells to mail to but the mail to address is
the formatted formula of the cell. The person didn't not
format the cell nor does she want it formatted.

Any help would be greatly appreciated.

 

[Frank Kabel]

Hi
one way:
Use the following macro to remove hyperlinks of a chosen selection
(after your data entry)
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html

for a couple of macros that will work.