Excel,how to turn off "send to" function when highlighting cells?

[Guest]

How do you turn off the "send to" automatic email function when you mouse
over or highlight a cell. A short click launches email and a long click
highlights the cell without launching email, but this drives you crazy.

 

[Guest]

Are these cells with hyperlinks or email addresses in them?

If you right-click in the cell, there is an option to remove the hyperlink.

I also think that if you hold CTRL when you click in a cell, that forces
Excel to ignore the hyperlink/email address.

Finally, if you have many cells with hyperlinks/email addresses there is
some code you can add which will automatically remove them all. Something
like this would do it:
http://www.tech-recipes.com/microsoft_office_tips1323.html

 

[Dave Peterson]

Remove the hyperlink.
Select the cell
edit|hyperlink|click the remove the hyperlink

If you're using xl2002+, you can stop email addresses from becoming hyperlinks
when you type them:
tools|autocorrect options|autoformat as you type tab|
uncheck "internet and network paths with hyperlinks" box

Or start your entry with an apostrophe:
'(e-mail address removed)

 

[Guest]

Thanks Dave that's really great. What a relief.
David.

 

[Guest]

Thanks Dave, good job.
David.

Remove the hyperlink.
Select the cell
edit|hyperlink|click the remove the hyperlink

If you're using xl2002+, you can stop email addresses from becoming hyperlinks
when you type them:
tools|autocorrect options|autoformat as you type tab|
uncheck "internet and network paths with hyperlinks" box

Or start your entry with an apostrophe:
'(e-mail address removed)