ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Hyperlinks (https://www.excelbanter.com/setting-up-configuration-excel/54101-hyperlinks.html)

Bil

Hyperlinks
 
How do I globally turn off the automatic addition of a hyperlink when I type
an e-mail address is a cell in Excel 2000?

Anne Troy

Hyperlinks
 
You don't, Bil. But you can try something like this:
http://vbaexpress.com/kb/getarticle.php?kb_id=73
Put a button on your toolbar for it, or you could place it in the
Workbook_Save or Workbook_Close or something.
Change the range from ("A1:A10") to ("A:IV") to make it work on the entire
worksheet.
************
Anne Troy
www.OfficeArticles.com


"Bil" wrote in message
...
How do I globally turn off the automatic addition of a hyperlink when I
type
an e-mail address is a cell in Excel 2000?





All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com