Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 4th 08, 11:36 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 4th 08, 02:07 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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   Report Post  
Old June 4th 08, 04:23 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 4th 08, 04:38 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 4th 08, 05:51 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 5th 08, 12:21 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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   Report Post  
Old June 5th 08, 09:50 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 5th 08, 11:24 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default Disabeling Hyperlinks

Fine for me, too! Thanx!

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

  #9   Report Post  
Old June 5th 08, 01:17 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old June 5th 08, 02:14 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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 ... ;-)


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
Hyperlinks: Hyperlinks change on copy/paste? Rick S. Excel Worksheet Functions 0 November 13th 07 08:19 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! jacob735 Excel Discussion (Misc queries) 1 June 22nd 07 12:57 AM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM
Hyperlinks Tom W Excel Discussion (Misc queries) 3 April 6th 05 12:44 AM


All times are GMT +1. The time now is 12:24 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017