Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I prevent Excel from automatically creating hyperlinks? keholcomb Excel Discussion (Misc queries) 2 July 1st 09 05:44 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH ROB Excel Discussion (Misc queries) 2 April 2nd 07 01:13 PM
How do I prevent Hyperlinks from changing when saved? Doug Excel Discussion (Misc queries) 0 March 13th 06 01:15 AM
How can I prevent Excel 2000 from inserting hyperlinks? RJL Jr. Setting up and Configuration of Excel 1 May 20th 05 12:15 PM


All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"