| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Severing links to list names when moving sheets between workbooks
When I move sheets to another spreadsheet, is there a way to automatically
sever the links so that it doesnt keep asking about list names? Can anyone advise of direct me? Thanks,Roger |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Severing links to list names when moving sheets between workbooks
Roger,
see if this works for you. Sub RemoveLinks() Dim Link As Variant With ActiveWorkbook For Each Link In .LinkSources .BreakLink Name:=Link, Type:=xlLinkTypeExcelLinks Next End With End Sub -- jb "Roger on Excel" wrote: When I move sheets to another spreadsheet, is there a way to automatically sever the links so that it doesnt keep asking about list names? Can anyone advise of direct me? Thanks,Roger |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct and moving sheets between workbooks error | Excel Discussion (Misc queries) | |||
| How do you maintain links when moving workbooks? | Excel Discussion (Misc queries) | |||
| Error moving sheets between workbooks | Excel Programming | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
| Moving sheets between workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
