| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent hyperlinks?
What property of a Range can be set so that text within the range is not
interpreted as a hyperlink? Thanks again, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent hyperlinks?
There isn't a property of a range to do this. You can go to the
Tools menu, choose AutoCorrect Options, then the "Autoformat As You Type" tab, and uncheck "Internet and network paths with hyperlinks" option. This will apply to new data entry. It won't change existing entries. You can delete hyperlinks and leave the text intact with Sub DeleteHyperlinks() ActiveSheet.Hyperlinks.Delete End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "keithb" wrote in message ... What property of a Range can be set so that text within the range is not interpreted as a hyperlink? Thanks again, Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent hyperlinks?
Take a look he
http://www.mcgimpsey.com/excel/nohyperlinks.html In article , "keithb" wrote: What property of a Range can be set so that text within the range is not interpreted as a hyperlink? Thanks again, Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I prevent Excel from automatically creating hyperlinks? | Excel Discussion (Misc queries) | |||
| Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
| HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
| How do I prevent Hyperlinks from changing when saved? | Excel Discussion (Misc queries) | |||
| How can I prevent Excel 2000 from inserting hyperlinks? | Setting up and Configuration of Excel | |||
Hybrid Mode
