RE: [belajar-excel] BreakLink

2016-12-14 Terurut Topik 'Dede Sulaeman' dede_sulae...@pinusmerahabadi.co.id [belajar-excel]
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

Re: [belajar-excel] BreakLink

2016-12-09 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
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

RE: [belajar-excel] BreakLink

2016-12-07 Terurut Topik 'Dede Sulaeman' dede_sulae...@pinusmerahabadi.co.id [belajar-excel]
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 :

RE: [belajar-excel] BreakLink

2016-12-06 Terurut Topik 'Dede Sulaeman' dede_sulae...@pinusmerahabadi.co.id [belajar-excel]
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