Temans,
Minta referensi code makro utk case2 berikut donk :
1. Membuat sheet baru dg menekan Command button.
kondisi : - sheet baru ada di workbook yg sama.
- nama sheet diinput oleh user
- posisi sheet baru diletakkan di paling kanan (move to end)
- command button ikut tercopy jg di sheet yg baru ( code jg bisa dijalanin di sheet yg baru )
- data inputan ( misal di range B4:B10 ) direset jadi kosong lagi
- Active cell ada di sheet baru cell B4
2. Mengunci cell tertentu pada kondisi tertentu.
kondisi : - misal if A1=0 ---> Range B5:B6 tidak bisa diinput
- ketika coba diinput keluar ceramah kyk gini misal " it is not necessary to be inputed, not applicable boss..."
- warna range dibikin jadi gray pada kondisi tsb
- kondisi berubah normal kembali ketika syarat tidak terpenuhi lg
3. Mengunci code yg kita bikin
kondisi : - ketika ada user mau coba lihat/mengedit codenya, dia harus punya password.
sementara ini dulu.. :D:D:D
cheers,
VDThis email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of PT. JGC Indonesia. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error.
| Resolusi 2010 XL-mania: terbitkan buku lagi... hehehe... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário