Dear Mr Kid,
Terima kasih atas masukannya Mr...
Salam,
DD
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 10 Desember 2016 3:43
To: BeExcel
Subject: Re: [belajar-excel] BreakLink
Hai Dede,
Coba begini :
dim link as variant
'jika ada
Hai Dede,
Coba begini :
dim link as variant
'jika ada sheet yang di-protect, lakukan loop setiap sheet disini dan isi
dengan proses unprotect sheet
'proses break link
for each link in thisworkbook.linksources(xlexcellinks)
thisworkbook.breaklink link,xllinktypeexcellinks
next link
'jika
Dear Mr Toby,
Makasih atas masukannya, saya pelajari dulu.
Salam,
DD
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 07 Desember 2016 17:44
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] BreakLink
Dear DD,
Coba Script ini :
Dear BeExceller,
Berikut script yang saya pakai :
Sub Macro2()
FlNm = Range("A1").Value
u = Range("F1").Value
For x = 1 To u
On Error Resume Next
Sheets("Sheet1").Select
Sheets("Sheet1").Move
ActiveWorkbook.BreakLink Name:="" & FlNm & "", Type:=xlExcelLinks
4 matches
Mail list logo