Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
penguino18
 
Posts: n/a
Default How can I disable all Hyperlinks in Excell 2000

I am trying to disable all hyperlinks without having to do each one
individually. Is there a way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default How can I disable all Hyperlinks in Excell 2000

try this

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

--
Don Guillett
SalesAid Software

"penguino18" wrote in message
...
I am trying to disable all hyperlinks without having to do each one
individually. Is there a way to do this?



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 enable or disable the paste option in excel 2000 mianmian Excel Worksheet Functions 0 September 2nd 05 09:57 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
hyperlinks in excell tom jan Excel Discussion (Misc queries) 1 April 25th 05 11:54 AM
Hyperlinks from a List, Excel 2000 jacob Excel Worksheet Functions 1 April 17th 05 02:25 PM
Hyperlinks in Excell syd Excel Worksheet Functions 1 October 28th 04 04:16 PM


All times are GMT +1. The time now is 08:55 AM.

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

About Us

"It's about Microsoft Excel"