Darren Smith
Well-known Member
- Joined
- Nov 23, 2020
- Messages
- 631
- Office Version
- 2019
- Platform
- Windows
Hi all
How can i copy worksheets from a workbook then keep the formulas but delete links to previous workbook?
I tried this but no luck.
Please somebody help
How can i copy worksheets from a workbook then keep the formulas but delete links to previous workbook?
I tried this but no luck.
Please somebody help
VBA Code:
Dim astrLinks As Variant
astrLinks = wkbDest.LinkSources(Type:=xlLinkTypeExcelLinks)
With wkbDest.Sheets(6)
.Select
.Unprotect
.BreakLink Name:=astrLinks(6), _
Type:=xlLinkTypeExcelLinks
.Protect
End With