Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Dim Kuning As Range, sheetName As String, Bikini
Set Kuning = Range(Range("B4"), Range("B4").End(xlDown))
If Target.Cells.Count = 1 Then
If Len(Target.Value) > 0 Then
If Not Intersect(Target, Kuning) Is Nothing Then
sheetName = "(" + CStr(Target(1, 0).Value) + ")"
If IsSheetFound(sheetName) Then
Sheets(sheetName).Select
Else
MsgBox "Tidak ada sheet benama " & sheetName & " ..tauk ?!", _
48, "Ellol.. Mang..."
Bikini = MsgBox("Apakah sheet tersebut mo di Bikini?!" & vbCrLf
& _
"Waduh,...... maksud teh di Bikinin?", 36, "Ellol.. Mang...")
If Bikini = vbYes Then
Sheet2.Copy After:=Sheets(Sheets.Count)
ActiveSheet.Range("b3") = Target(1, 0).Value
ActiveSheet.Name = sheetName
End If
End If
End If
End If
End If
Cancel = True
End Sub
taaa kituuu...
----- Original Message -----
From: Khozhot
To: belajar-excel
Sent: Monday, February 01, 2010 8:21 AM
Subject: Fwd: Re: [belajar-excel] Other Link
---------------------------------------
mods note
email ini masuk ke grups di folder spam
kenafa ya...
----------------------------------------
Colly......
Q resend lage dach, ternyata ada reportnya bahwa imel ini gak sampe
ke millist pada hal dah macuk sent folder.
Maaf q kurang telik. I made all of you confused about it. I guess.
Email sebelumnya ada dibawah email ini.
I am waiting for it, please.
TQ B4,
Wassalam.
...zhot thea
------- Forwarded message -------
From: Khozhot <[email protected]>
To: [email protected]
Cc:
Subject: Re: [belajar-excel] Other Link
Date: Sat, 30 Jan 2010 16:23:03 +0700
Aaa .... sou desu ka !?!
Hai, watashi wa wakarimasta. Doumo arigato gozaimasu xi...xi...xi.....
Sebenarnya q pengen buat schedule seperti terlampir.
Jadi begitu pencarian tidak diketemukan, tidak usah hubungi Team SAR. Yang
pasti q tanbahin agar langsung dibuatkan sheet tersebut getoch
xi...xi....xi....
Tapi,...... malah timbul masalah baru nech.
CELL yang berisi qty jadi ilang gak keliatan karena width nya gak memadai,
gimana yach codenya agar bisa autofit ketika langsung di kopi?
Maaf... jadi ngelunjak nech....... heu...heu....heu....
Wassalam.
...zhot thea