Okay, using XL2000 I entered an email address and was able to modify
its appearance via the 'Modify' button in the 'Styles' dialog, on the
'Font' tab. This does not change the behavior and so when I click on a
cell (as opposed to navigating to it via arrow keys) a single instance
of my mail app's 'new message' window opens with the email address
already entered in the 'To:' field.

When I want to edit a hyperlink I click an adjacent cell and use an
arrow key to navigate to it. To enter EditMode without having to click
the cell I use the keyboard shortcut 'F2'.

AFAIK, there's no intuitive/obvious way to turn off hyperlinks.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion