jadi maksudnya: - 2 sht (x dan y) very hidden - sht yang lain diselect sekaligus?
Salam, HK Sent from Samsung Mobile <div>-------- Original message --------</div><div>From: "'M.Ade Alfarid' [email protected] [belajar-excel]" <[email protected]> </div><div>Date:08/01/2015 20:13 (GMT+07:00) </div><div>To: [email protected] </div><div>Subject: Re: [belajar-excel] Macro pilih allsheet kecuali satu sheet </div><div> </div>Dear Pak HK, Supaya worksheet tersebut tidak ikut terselect dan selalu very hidden bagaimana? karena macro class module nya menselect semua sheet. Apakah bisa independent si worksheet tidak mau ikut terselect? M.Ade On Thu, 08 Jan 2015 20:22:30 +0700, Hendrik Karnadi [email protected] [belajar-excel] <[email protected]> wrote: CODE berisi langkah2 program yang akan dilakukan... Sent from Samsung Mobile -------- Original message -------- From: "'M.Ade Alfarid' [email protected] [belajar-excel]" Date:08/01/2015 19:49 (GMT+07:00) To: [email protected] Subject: Re: [belajar-excel] Macro pilih allsheet kecuali satu sheet Kok compile error, ya Pak HK? Private Sub kecuali_satu() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets If wks.Name <> "1" Or wks.Name <> "2" Then code.... End If Next wks End Sub Salam,Ade On Thu, 08 Jan 2015 20:05:33 +0700, Hendrik Karnadi [email protected] [belajar-excel] <[email protected]> wrote: Hai Ade, Coba begini...(milihnya satu2 pake looping) Dim wks as worksheet For each wks in thisworkbook.worksheets If wks .name <> "x" or wks.name <> "y" then CODE.... End If Next wks Salam, HK Sent from Samsung Mobile -------- Original message -------- From: "'M.Ade Alfarid' [email protected] [belajar-excel]" Date:08/01/2015 19:05 (GMT+07:00) To: [email protected] Subject: [belajar-excel] Macro pilih allsheet kecuali satu sheet [1 Attachment] Dear, Bagaimana macro memilih all worksheet kecuali satu atau lebih? Ade -- -- --
