How to prevent opening email program

  • Thread starter Thread starter Bob Richardson
  • Start date Start date
B

Bob Richardson

I have a column with email addresses. When I click on one...to edit it...my
email program automatically opens. How can I prevent this action. I'm
using Excel 2002.

I followed the instructions on how to "Deactivate several hyperlinks at
once". This seemed to work for one click. But as soon as focus changed to
another cell, the previously clicked cell then became an active hyperlink to
my email program. (underlined, in blue, and ready to open my email program)

There must be a way to deactivate at this "feature" TIA
 
Bob,

A simple way is like this:

right click on the hyperlink,
in the little menu that pops up click on "hyperlink",
of the options that follow click on "delete hyperlink" (or words with the
same meaning, I use the Dutch version).

That is all.

Jack Sons
The Netherlands
 
[snip]
In Excel 2002 you can turn it of

Tools>Auto correct Options
See the <AutoFormat as You Type> Tab
Click to expand...

Thanks Ron, this is what I was looking for.

But now I have another problem in my spreadsheet. Everytime I open it, I'm
asked to Enable or Disable Macros. This is a pain, since there are no
macros in my Workbook. Earlier I had tried to use the macro approach that
was suggested. Then I deleted the macro. Now when I open the workbook, I
must answer this macro question before continuing. What's going on?
 
Delete the empty module also Bob.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




Bob Richardson said:
[snip]
In Excel 2002 you can turn it of

Tools>Auto correct Options
See the <AutoFormat as You Type> Tab
Click to expand...

Thanks Ron, this is what I was looking for.

But now I have another problem in my spreadsheet. Everytime I open it, I'm
asked to Enable or Disable Macros. This is a pain, since there are no
macros in my Workbook. Earlier I had tried to use the macro approach that
was suggested. Then I deleted the macro. Now when I open the workbook, I
must answer this macro question before continuing. What's going on?
Click to expand...
 
Back
Top