Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 8
Default Ghost Links - Remove via VBA?

hi there

i havea new workbook copied from an 'older' one.

I want to remove all the links from the new one
i have tried 'breaklinks' through the edit menu
i have tried findlinks.xla - which works great, but i cannot use it
through vba??

any ideas?

  #2   Report Post  
Posted to microsoft.public.excel.links
zz zz is offline
external usenet poster
 
Posts: 32
Default Ghost Links - Remove via VBA?

this should do the job


Private Sub deletelinks()
Application.ActiveSheet.Hyperlinks.Delete
End Sub


--
hope this help.
---
zz [MX]
cuasi-musico,semi-poeta y loco


wrote in message
oups.com...
hi there

i havea new workbook copied from an 'older' one.

I want to remove all the links from the new one
i have tried 'breaklinks' through the edit menu
i have tried findlinks.xla - which works great, but i cannot use it
through vba??

any ideas?



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
Edit Links: Changing links on a protected worksheet Halibut68 Excel Discussion (Misc queries) 0 April 28th 06 11:03 AM
Can't Insert of remove worksheet in an existing workbook beginer1 Excel Discussion (Misc queries) 4 January 25th 06 03:06 AM
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe Excel Worksheet Functions 1 September 29th 05 10:33 PM
Update links prompt not wanted neeraj Excel Discussion (Misc queries) 5 September 23rd 05 06:34 PM
Ghost Links [email protected] Links and Linking in Excel 3 August 20th 05 04:02 PM


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

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

About Us

"It's about Microsoft Excel"