Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Ghost Links | Links and Linking in Excel |