Thanks Garry, I selected the Email column and Styles and was able to globally change the font. Under Hyperlink was unable to see a Modify button.
Typing an email addy becomes blue and underlined and when clicking on it opens up multiple copies of internet explorer until it times out.
Most aggravating lol, this feature has to go..... I need to disable anything to do with Hyperlink.
Thanks again,
David...
MSOffice 2000
Excel
Quote:
Originally Posted by GS[_2_]
Estam explained :
Spencer101;1601270 Wrote:
Hi,
If you right click on the cell and select "Remove Hyperlink" the email
address will just become text that you can edit.
There is an option to turn this function off but I'm not sure where it
is in your version of Excel. Try looking for setting options for "Auto
Complete" and you'll be able to switch it off here.
Hope that's of help.
S.
Office Excel 2000
Thank you, the right click on the cell worked.
Any time I type in an email address and press Enter it turns into a
different font and is underlined. Does this mean every cell I have to
remove this hyperlink.
I'm hoping someone can point me to a global setting where I can turn off
this email feature.
Again, many thanks for your help.
You can change the global setting for how hyperlinks display via the
Styles dialog. Select Hyperlinks and remove the undesired formatting
via the Modify button.
Also, it might help to get in the habit of using F2 to enter EditMode
for cells you want to edit. This places the carat at the end of
existing contents. In the case of cells with hyperlinks, select a
normal cell and use the arrow keys to activate the cell you want to
edit.
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public. vb.general.discussion |