Forum Discussion
Kenneth Rushton
Nov 24, 2017Copper Contributor
automatic e-mail composition
I have an Excel spreadsheet containing e-mail addresses. How can I stop my e-mail program (Thunderbird) composing an e-mail when I click on a cell?
Haytham Amairah
Nov 24, 2017Silver Contributor
Kenneth,
Highlight the cells that contain hyperlinks, then right-click, and select Remove Hyperlink as shown in the below screenshot:
To prevent that behavior from happening in the future, do the following:
- Go to Excel Options >> Proofing
- Click on the AutoCorrect Options button.
- From the AutoCorrect dialog box, select the second tab.
- Clear the CheckBox labeled: (Internet and network paths with hyperlinks).
- Click OK.
Kenneth Rushton
Nov 24, 2017Copper Contributor
Thank you for your answer, but they are not hyperlinks, just plain text, and the CheckBox labelled:(Internet and network paths with hyperlinks). is clear.
- Haytham AmairahNov 24, 2017Silver Contributor
If so, then something is wrong with the Thunderbird itself!
- Kenneth RushtonNov 25, 2017Copper Contributor
If I make Windows Mail the default e-mail app the same thing happens
- SergeiBaklanNov 25, 2017Diamond Contributor
Yes, that doesn't matter, default email client is triggered by something. Is it possible to receive some sample file?
- SergeiBaklanNov 24, 2017Diamond Contributor
If that macro-enabled workbook it could be on click macro which opens email client
- Kenneth RushtonNov 25, 2017Copper Contributor
Macros are disabled.