Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default Getting Rid of Hyperlinks and Restoring them to a double

How do you get rid of Hyperlinks and restoring them to a double in VBA code?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default Getting Rid of Hyperlinks and Restoring them to a double

Try selecting them and then click Edit/Clear/Formats on the menu bar.

--
Rick (MVP - Excel)



"Philosophaie" wrote in message
...
How do you get rid of Hyperlinks and restoring them to a double in VBA
code?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default Getting Rid of Hyperlinks and Restoring them to a double

I found this and it works:

ActiveSheets.Cells.Hyperlinks.Delete


"Rick Rothstein" wrote:

Try selecting them and then click Edit/Clear/Formats on the menu bar.

--
Rick (MVP - Excel)



"Philosophaie" wrote in message
...
How do you get rid of Hyperlinks and restoring them to a double in VBA
code?


.

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
Restoring Gridlines Abradaxis Excel Worksheet Functions 3 December 23rd 09 04:56 PM
Restoring izmn19 Excel Discussion (Misc queries) 2 April 13th 08 08:17 PM
restoring toolbars Josh C Excel Programming 1 May 3rd 07 12:50 AM
Restoring Links Adam Excel Programming 1 November 9th 04 08:09 PM
Activating & Restoring Eloy[_2_] Excel Programming 0 October 22nd 04 09:11 PM


All times are GMT +1. The time now is 07:53 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"