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]: 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]:
[belajar-excel] Macro pilih allsheet kecuali satu sheet [1 Attachment]
Dear,
Bagaimana macro memilih all worksheet kecuali satu atau lebih?
Ade
--
--
--
