A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Disabeling Hyperlinks



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2008, 11:36 AM posted to microsoft.public.excel.links
Nathalie Krochmann
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Hi everyone,

any ideas how to avoid email and internet addresses generally? I'm tired
of removing each hyperlink.

Thanks in advance,
Nathalie
  #2  
Old June 4th, 2008, 02:07 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Disabeling Hyperlinks

I assume you mean you want them not to be created as hyperlinks
automatically when the format is recognised on data entry?

You didn't mention which version of Excel (it always helps).

In versions prior to 2007,
Tools AutoCorrect options Autoformat as you type uncheck
"Internet and network paths with hyperlinks"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3  
Old June 4th, 2008, 04:23 PM posted to microsoft.public.excel.links
Otto von Elkenhof
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Thanks, that was exactly my question too.

Bill Manville schrieb:
I assume you mean you want them not to be created as hyperlinks
automatically when the format is recognised on data entry?

You didn't mention which version of Excel (it always helps).

In versions prior to 2007,
Tools AutoCorrect options Autoformat as you type uncheck
"Internet and network paths with hyperlinks"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #4  
Old June 4th, 2008, 04:38 PM posted to microsoft.public.excel.links
Andreas Nachtmann
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

I have another question related to this topic:
When I have a row or a column with cells with hyperlinks is there a
possibility to change this in one step? Normally I just click right on
every cell to remove the hypertext. A lot of work ...

regards, Andreas.

Bill Manville schrieb:
I assume you mean you want them not to be created as hyperlinks
automatically when the format is recognised on data entry?

You didn't mention which version of Excel (it always helps).

In versions prior to 2007,
Tools AutoCorrect options Autoformat as you type uncheck
"Internet and network paths with hyperlinks"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #5  
Old June 4th, 2008, 05:51 PM posted to microsoft.public.excel.links
Claudia Meischner
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Mine, too.

Otto von Elkenhof schrieb:
Thanks, that was exactly my question too.

Bill Manville schrieb:
I assume you mean you want them not to be created as hyperlinks
automatically when the format is recognised on data entry?

You didn't mention which version of Excel (it always helps).

In versions prior to 2007, Tools AutoCorrect options Autoformat as
you type uncheck "Internet and network paths with hyperlinks"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #6  
Old June 5th, 2008, 12:21 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Disabeling Hyperlinks

Just select the cells and run this macro

Sub DeleteHyperlinksFromSelection()
Selection.Hyperlinks.Delete
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #7  
Old June 5th, 2008, 09:50 AM posted to microsoft.public.excel.links
Lilo Schwan
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Great Script! Works fine for me!

Bill Manville schrieb:
Just select the cells and run this macro

Sub DeleteHyperlinksFromSelection()
Selection.Hyperlinks.Delete
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #8  
Old June 5th, 2008, 11:24 AM posted to microsoft.public.excel.links
Konrad Krause
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Fine for me, too! Thanx!

Lilo Schwan schrieb:
Great Script! Works fine for me!

  #9  
Old June 5th, 2008, 01:17 PM posted to microsoft.public.excel.links
Lucy Hachmann
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Konrad Krause schrieb:
Fine for me, too! Thanx!

Lilo Schwan schrieb:
Great Script! Works fine for me!


Newsgroups are sometimes so useful!
  #10  
Old June 5th, 2008, 02:14 PM posted to microsoft.public.excel.links
Hanno Manns
external usenet poster
 
Posts: 1
Default Disabeling Hyperlinks

Lucy Hachmann schrieb:
Newsgroups are sometimes so useful!


You're right. Even if I didn't need this feature at the moment, I was
lucky to find a solution for a problem I never had up to now ... ;-)
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.