Dear Mr. Vidi,
Terlampir adalah jawaban dari saya untuk masalah yang Anda hadapi.
Semoga bermanfaat.
Regards,
Lahar
--- Vidi Ardyanto <Vidi.Ardyanto@
> 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,
> VD
> This 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.
>
>
------------
Get the new Internet Explorer 8 optimized for Yahoo! JAPAN
http://pr.mail.
| 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