| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
