Jumat, 15 Januari 2016

[belajar-excel] Digest Number 3720

15 Messages

Digest #3720
1a
Re: cari data by "imam cahyo yuwono"
1b
Re: cari data by "Mr. Kid" nmkid.family@ymail.com
3a
Re: Status Report Otomatis sesuai jumlah atau tanggal by "Fajar Fatahillah" fajar.fatahillah
4b
Re: Disable right click di tab sheet dan menu bar by "hendrik karnadi" hendrikkarnadi
8a
Bls: [belajar-excel] Split Text by "anas hasbullah" hasbullah_anas

Messages

Thu Jan 14, 2016 8:29 pm (PST) . Posted by:

"imam cahyo yuwono"

wah ada account yang nyasar ke saya yaaa ? hahhahah....lumayan nambah ilmu heheheh..


On Thursday, January 14, 2016 6:48 AM, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  dear Mr Toby
maaf Mr Toby saya juga masih bingung menyusun kode vba nya intinya ingin mencari data dari pilihan 2 kategori menggunakan option button pada textbox di ketik yang akan dicari dan listbox menampilkan secara langsungkalo pun ada contoh yang mendekati juga tidak apa-apa sekalian menambah ilmu vba sayaterima kasih


On Wednesday, January 13, 2016 11:50 PM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


 
| Dear Imam,Bisa di lampirkan kode VBAnya ngga...Sent from Yahoo Mail on Android |

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] cari data [1 Attachment]
Sent: Wed, Jan 13, 2016 8:23:26 AM


|   dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
|

#yiv6572664789 #yiv6572664789 -- #yiv6572664789ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6572664789 #yiv6572664789ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6572664789 #yiv6572664789ygrp-mkp #yiv6572664789hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6572664789 #yiv6572664789ygrp-mkp #yiv6572664789ads {margin-bottom:10px;}#yiv6572664789 #yiv6572664789ygrp-mkp .yiv6572664789ad {padding:0 0;}#yiv6572664789 #yiv6572664789ygrp-mkp .yiv6572664789ad p {margin:0;}#yiv6572664789 #yiv6572664789ygrp-mkp .yiv6572664789ad a {color:#0000ff;text-decoration:none;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ygrp-lc {font-family:Arial;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ygrp-lc #yiv6572664789hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ygrp-lc .yiv6572664789ad {margin-bottom:10px;padding:0 0;}#yiv6572664789 #yiv6572664789actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6572664789 #yiv6572664789activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6572664789 #yiv6572664789activity span {font-weight:700;}#yiv6572664789 #yiv6572664789activity span:first-child {text-transform:uppercase;}#yiv6572664789 #yiv6572664789activity span a {color:#5085b6;text-decoration:none;}#yiv6572664789 #yiv6572664789activity span span {color:#ff7900;}#yiv6572664789 #yiv6572664789activity span .yiv6572664789underline {text-decoration:underline;}#yiv6572664789 .yiv6572664789attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6572664789 .yiv6572664789attach div a {text-decoration:none;}#yiv6572664789 .yiv6572664789attach img {border:none;padding-right:5px;}#yiv6572664789 .yiv6572664789attach label {display:block;margin-bottom:5px;}#yiv6572664789 .yiv6572664789attach label a {text-decoration:none;}#yiv6572664789 blockquote {margin:0 0 0 4px;}#yiv6572664789 .yiv6572664789bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6572664789 .yiv6572664789bold a {text-decoration:none;}#yiv6572664789 dd.yiv6572664789last p a {font-family:Verdana;font-weight:700;}#yiv6572664789 dd.yiv6572664789last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6572664789 dd.yiv6572664789last p span.yiv6572664789yshortcuts {margin-right:0;}#yiv6572664789 div.yiv6572664789attach-table div div a {text-decoration:none;}#yiv6572664789 div.yiv6572664789attach-table {width:400px;}#yiv6572664789 div.yiv6572664789file-title a, #yiv6572664789 div.yiv6572664789file-title a:active, #yiv6572664789 div.yiv6572664789file-title a:hover, #yiv6572664789 div.yiv6572664789file-title a:visited {text-decoration:none;}#yiv6572664789 div.yiv6572664789photo-title a, #yiv6572664789 div.yiv6572664789photo-title a:active, #yiv6572664789 div.yiv6572664789photo-title a:hover, #yiv6572664789 div.yiv6572664789photo-title a:visited {text-decoration:none;}#yiv6572664789 div#yiv6572664789ygrp-mlmsg #yiv6572664789ygrp-msg p a span.yiv6572664789yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6572664789 .yiv6572664789green {color:#628c2a;}#yiv6572664789 .yiv6572664789MsoNormal {margin:0 0 0 0;}#yiv6572664789 o {font-size:0;}#yiv6572664789 #yiv6572664789photos div {float:left;width:72px;}#yiv6572664789 #yiv6572664789photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6572664789 #yiv6572664789photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6572664789 #yiv6572664789reco-category {font-size:77%;}#yiv6572664789 #yiv6572664789reco-desc {font-size:77%;}#yiv6572664789 .yiv6572664789replbq {margin:4px;}#yiv6572664789 #yiv6572664789ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6572664789 #yiv6572664789ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6572664789 #yiv6572664789ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6572664789 #yiv6572664789ygrp-mlmsg select, #yiv6572664789 input, #yiv6572664789 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6572664789 #yiv6572664789ygrp-mlmsg pre, #yiv6572664789 code {font:115% monospace;}#yiv6572664789 #yiv6572664789ygrp-mlmsg * {line-height:1.22em;}#yiv6572664789 #yiv6572664789ygrp-mlmsg #yiv6572664789logo {padding-bottom:10px;}#yiv6572664789 #yiv6572664789ygrp-msg p a {font-family:Verdana;}#yiv6572664789 #yiv6572664789ygrp-msg p#yiv6572664789attach-count span {color:#1E66AE;font-weight:700;}#yiv6572664789 #yiv6572664789ygrp-reco #yiv6572664789reco-head {color:#ff7900;font-weight:700;}#yiv6572664789 #yiv6572664789ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ov li a {font-size:130%;text-decoration:none;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6572664789 #yiv6572664789ygrp-sponsor #yiv6572664789ov ul {margin:0;padding:0 0 0 8px;}#yiv6572664789 #yiv6572664789ygrp-text {font-family:Georgia;}#yiv6572664789 #yiv6572664789ygrp-text p {margin:0 0 1em 0;}#yiv6572664789 #yiv6572664789ygrp-text tt {font-size:120%;}#yiv6572664789 #yiv6572664789ygrp-vital ul li:last-child {border-right:none !important;}#yiv6572664789

Thu Jan 14, 2016 8:32 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

hehehe...
bukan nyasar ke akun Anda loh Pak.
Tapi ada postingan yang membuat topik di milis menjadi rancu karena ada
beberapa kasus yang berbeda.

Jadi, setiap topik adalah milik seluruh member milis.
Kesediaan setiap anggota untuk menjaga agar topik menjadi spesifik berdasar
kasus yang diutarakan oleh pengirim pertama topik tersebut akan memudahkan
proses pencarian kasus-kasus lama di milis.

Wassalam,
Kid

On Fri, Jan 15, 2016 at 11:13 AM, imam cahyo yuwono chyywn@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> wah ada account yang nyasar ke saya yaaa ? hahhahah....
> lumayan nambah ilmu heheheh..
>
>
> On Thursday, January 14, 2016 6:48 AM, "imam cahyo yuwono chyywn@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> dear Mr Toby
>
> maaf Mr Toby saya juga masih bingung menyusun kode vba nya intinya ingin
> mencari data dari pilihan 2 kategori menggunakan option button pada textbox
> di ketik yang akan dicari dan listbox menampilkan secara langsung
> kalo pun ada contoh yang mendekati juga tidak apa-apa sekalian menambah
> ilmu vba saya
> terima kasih
>
>
> On Wednesday, January 13, 2016 11:50 PM, "Toby kenzo tobykenzo@yahoo.co.id
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Dear Imam,
> Bisa di lampirkan kode VBAnya ngga...
> Sent from Yahoo Mail on Android
> <http://overview.mail.yahoo.com/mobile/?.src=Android>
>
> ------------------------------
> * From: * imam cahyo yuwono chyywn@yahoo.com [belajar-excel] <
> belajar-excel@yahoogroups.com>;
> * To: * <belajar-excel@yahoogroups.com>;
> * Subject: * [belajar-excel] cari data [1 Attachment]
> * Sent: * Wed, Jan 13, 2016 8:23:26 AM
>
>
> dear para expert
>
> mohon bantuannya membuat pencarian data dengan contoh form seperti yang
> saya lampirkan
>
>
> terima kasih
>
>
>
>
>
>

Thu Jan 14, 2016 10:25 pm (PST) . Posted by:

"Danny Prasetyo" danny_06791

body { font-family: "Calibri","Slate
Pro",sans-serif,"sans-serif"; color:#262626 } Terima kasih mas
Toby...File yang dikirim mas Toby sesuai harapan. Tapi jika ada
500 nama, apa ada solusi kode VBA selain If dan elseif ? Agar
lebih singkat.
Regards,

Danny Prasetyo

Fri Jan 15, 2016 1:59 am (PST) . Posted by:

tobykenzo

Dear Danny,


ada solusinya, tergantung konsepnya mau gimana...


TerimaKasih.

Thu Jan 14, 2016 8:42 pm (PST) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

tidak ada kriteria resmi , hanya pembagian report per dua pekan berjumlah 10 report,
jadi, ketika status report adalah report, maka harus dikerjakan , namun pengerjaannya dibagi per dua pekan, pekan pertama (7 jan ) 10 report, dua pekan berikutnya (21 Jan) 10 report berikutnya.
 Best Regards, Fajar Fatahillah

On Friday, January 15, 2016 9:47 AM, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Hai Fajar,

Boleh tahu apa kriterianya sehingga report tanggal 13-Dec-2015 sampai 22-Feb-2016 dipilih tanggal pengerjaan 21-Jan-2016 ?
Adakah ketentuan yang lebih spesifik tanpa bantuan nilai tanggal di D1 ?

Regards,
Kid

2016-01-13 15:22 GMT+07:00 Fajar Fatahillah fajar.fatahillah@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Dear Master Excel,saya ada kasus untuk pembuatan report,misal ada 20 data yang statusnya report, tapi hanya dikerjakan 10 report saja untuk pekan ini, dan pekan depannya 10 report berikutnya, dan terus berulang sampai tanggal durasi reportnya berakhir.Adakah formula yang bisa memudahkan kita? pengennya ada satu kolom yang menyatakan bahwa 10 report dikerjakan pada pekan ini/ tgl tertentu dan 10 report pada pekan berikutnya.terlampir contoh datanya.
Terima kasih sebelumnya Best Regards, Fajar Fatahillah

__,_._

#yiv4985755939 #yiv4985755939 -- #yiv4985755939ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4985755939 #yiv4985755939ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4985755939 #yiv4985755939ygrp-mkp #yiv4985755939hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4985755939 #yiv4985755939ygrp-mkp #yiv4985755939ads {margin-bottom:10px;}#yiv4985755939 #yiv4985755939ygrp-mkp .yiv4985755939ad {padding:0 0;}#yiv4985755939 #yiv4985755939ygrp-mkp .yiv4985755939ad p {margin:0;}#yiv4985755939 #yiv4985755939ygrp-mkp .yiv4985755939ad a {color:#0000ff;text-decoration:none;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ygrp-lc {font-family:Arial;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ygrp-lc #yiv4985755939hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ygrp-lc .yiv4985755939ad {margin-bottom:10px;padding:0 0;}#yiv4985755939 #yiv4985755939actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4985755939 #yiv4985755939activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4985755939 #yiv4985755939activity span {font-weight:700;}#yiv4985755939 #yiv4985755939activity span:first-child {text-transform:uppercase;}#yiv4985755939 #yiv4985755939activity span a {color:#5085b6;text-decoration:none;}#yiv4985755939 #yiv4985755939activity span span {color:#ff7900;}#yiv4985755939 #yiv4985755939activity span .yiv4985755939underline {text-decoration:underline;}#yiv4985755939 .yiv4985755939attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4985755939 .yiv4985755939attach div a {text-decoration:none;}#yiv4985755939 .yiv4985755939attach img {border:none;padding-right:5px;}#yiv4985755939 .yiv4985755939attach label {display:block;margin-bottom:5px;}#yiv4985755939 .yiv4985755939attach label a {text-decoration:none;}#yiv4985755939 blockquote {margin:0 0 0 4px;}#yiv4985755939 .yiv4985755939bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4985755939 .yiv4985755939bold a {text-decoration:none;}#yiv4985755939 dd.yiv4985755939last p a {font-family:Verdana;font-weight:700;}#yiv4985755939 dd.yiv4985755939last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4985755939 dd.yiv4985755939last p span.yiv4985755939yshortcuts {margin-right:0;}#yiv4985755939 div.yiv4985755939attach-table div div a {text-decoration:none;}#yiv4985755939 div.yiv4985755939attach-table {width:400px;}#yiv4985755939 div.yiv4985755939file-title a, #yiv4985755939 div.yiv4985755939file-title a:active, #yiv4985755939 div.yiv4985755939file-title a:hover, #yiv4985755939 div.yiv4985755939file-title a:visited {text-decoration:none;}#yiv4985755939 div.yiv4985755939photo-title a, #yiv4985755939 div.yiv4985755939photo-title a:active, #yiv4985755939 div.yiv4985755939photo-title a:hover, #yiv4985755939 div.yiv4985755939photo-title a:visited {text-decoration:none;}#yiv4985755939 div#yiv4985755939ygrp-mlmsg #yiv4985755939ygrp-msg p a span.yiv4985755939yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4985755939 .yiv4985755939green {color:#628c2a;}#yiv4985755939 .yiv4985755939MsoNormal {margin:0 0 0 0;}#yiv4985755939 o {font-size:0;}#yiv4985755939 #yiv4985755939photos div {float:left;width:72px;}#yiv4985755939 #yiv4985755939photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4985755939 #yiv4985755939photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4985755939 #yiv4985755939reco-category {font-size:77%;}#yiv4985755939 #yiv4985755939reco-desc {font-size:77%;}#yiv4985755939 .yiv4985755939replbq {margin:4px;}#yiv4985755939 #yiv4985755939ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4985755939 #yiv4985755939ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4985755939 #yiv4985755939ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4985755939 #yiv4985755939ygrp-mlmsg select, #yiv4985755939 input, #yiv4985755939 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4985755939 #yiv4985755939ygrp-mlmsg pre, #yiv4985755939 code {font:115% monospace;}#yiv4985755939 #yiv4985755939ygrp-mlmsg * {line-height:1.22em;}#yiv4985755939 #yiv4985755939ygrp-mlmsg #yiv4985755939logo {padding-bottom:10px;}#yiv4985755939 #yiv4985755939ygrp-msg p a {font-family:Verdana;}#yiv4985755939 #yiv4985755939ygrp-msg p#yiv4985755939attach-count span {color:#1E66AE;font-weight:700;}#yiv4985755939 #yiv4985755939ygrp-reco #yiv4985755939reco-head {color:#ff7900;font-weight:700;}#yiv4985755939 #yiv4985755939ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ov li a {font-size:130%;text-decoration:none;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4985755939 #yiv4985755939ygrp-sponsor #yiv4985755939ov ul {margin:0;padding:0 0 0 8px;}#yiv4985755939 #yiv4985755939ygrp-text {font-family:Georgia;}#yiv4985755939 #yiv4985755939ygrp-text p {margin:0 0 1em 0;}#yiv4985755939 #yiv4985755939ygrp-text tt {font-size:120%;}#yiv4985755939 #yiv4985755939ygrp-vital ul li:last-child {border-right:none !important;}#yiv4985755939

Thu Jan 14, 2016 10:12 pm (PST) . Posted by:

tobykenzo

Dear Tio,


1. Gunakan method "Worksheet_BeforeRightClick"
Untuk meng non aktifkan yg lain gunakan method Application.OnKeys
2. Gunakan Custom UI Editor (sdh pernah di bahas di forum ini) untuk meng non aktifkan beberapa custom Ribbon


TerimaKasih.

Thu Jan 14, 2016 11:25 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Tio,Coba lihat file/folder terlampir,1. Ga bisa diklik kanan dan Cut,Copy ga bisa diPaste2. Folder Ribbon Change yang berisi link untuk membuat menu sendiri serta contoh2nya.
Ini saya dapat dari milis dan internet.
Salam, HK

From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 15 January 2016, 9:26
Subject: [belajar-excel] Disable right click di tab sheet dan menu bar

  Salam Excel Expert, Saya mau bertanya : 1.     Bagaimana code vba untuk disable right click di tab sheet ? 2.     Adakah code vba untuk menon-aktifkan menu bar dan command bar di excel hanya di 1 workbook yang dituju ? dan memunculkan dengan menu sendiri ? Saya sudah cari di google, tapi tidak berhasil-berhasil juga.   Terima kasih bantuannya. Semoga Tuhan YME membalasnya. Amiin.   Salam, Tio  
| | |
| | | |
| | | | |

    #yiv0387691429 #yiv0387691429 -- #yiv0387691429ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0387691429 #yiv0387691429ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0387691429 #yiv0387691429ygrp-mkp #yiv0387691429hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0387691429 #yiv0387691429ygrp-mkp #yiv0387691429ads {margin-bottom:10px;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad {padding:0 0;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad p {margin:0;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad a {color:#0000ff;text-decoration:none;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ygrp-lc {font-family:Arial;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ygrp-lc #yiv0387691429hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ygrp-lc .yiv0387691429ad {margin-bottom:10px;padding:0 0;}#yiv0387691429 #yiv0387691429actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0387691429 #yiv0387691429activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0387691429 #yiv0387691429activity span {font-weight:700;}#yiv0387691429 #yiv0387691429activity span:first-child {text-transform:uppercase;}#yiv0387691429 #yiv0387691429activity span a {color:#5085b6;text-decoration:none;}#yiv0387691429 #yiv0387691429activity span span {color:#ff7900;}#yiv0387691429 #yiv0387691429activity span .yiv0387691429underline {text-decoration:underline;}#yiv0387691429 .yiv0387691429attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0387691429 .yiv0387691429attach div a {text-decoration:none;}#yiv0387691429 .yiv0387691429attach img {border:none;padding-right:5px;}#yiv0387691429 .yiv0387691429attach label {display:block;margin-bottom:5px;}#yiv0387691429 .yiv0387691429attach label a {text-decoration:none;}#yiv0387691429 blockquote {margin:0 0 0 4px;}#yiv0387691429 .yiv0387691429bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0387691429 .yiv0387691429bold a {text-decoration:none;}#yiv0387691429 dd.yiv0387691429last p a {font-family:Verdana;font-weight:700;}#yiv0387691429 dd.yiv0387691429last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0387691429 dd.yiv0387691429last p span.yiv0387691429yshortcuts {margin-right:0;}#yiv0387691429 div.yiv0387691429attach-table div div a {text-decoration:none;}#yiv0387691429 div.yiv0387691429attach-table {width:400px;}#yiv0387691429 div.yiv0387691429file-title a, #yiv0387691429 div.yiv0387691429file-title a:active, #yiv0387691429 div.yiv0387691429file-title a:hover, #yiv0387691429 div.yiv0387691429file-title a:visited {text-decoration:none;}#yiv0387691429 div.yiv0387691429photo-title a, #yiv0387691429 div.yiv0387691429photo-title a:active, #yiv0387691429 div.yiv0387691429photo-title a:hover, #yiv0387691429 div.yiv0387691429photo-title a:visited {text-decoration:none;}#yiv0387691429 div#yiv0387691429ygrp-mlmsg #yiv0387691429ygrp-msg p a span.yiv0387691429yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0387691429 .yiv0387691429green {color:#628c2a;}#yiv0387691429 .yiv0387691429MsoNormal {margin:0 0 0 0;}#yiv0387691429 o {font-size:0;}#yiv0387691429 #yiv0387691429photos div {float:left;width:72px;}#yiv0387691429 #yiv0387691429photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0387691429 #yiv0387691429photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0387691429 #yiv0387691429reco-category {font-size:77%;}#yiv0387691429 #yiv0387691429reco-desc {font-size:77%;}#yiv0387691429 .yiv0387691429replbq {margin:4px;}#yiv0387691429 #yiv0387691429ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0387691429 #yiv0387691429ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0387691429 #yiv0387691429ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0387691429 #yiv0387691429ygrp-mlmsg select, #yiv0387691429 input, #yiv0387691429 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0387691429 #yiv0387691429ygrp-mlmsg pre, #yiv0387691429 code {font:115% monospace;}#yiv0387691429 #yiv0387691429ygrp-mlmsg * {line-height:1.22em;}#yiv0387691429 #yiv0387691429ygrp-mlmsg #yiv0387691429logo {padding-bottom:10px;}#yiv0387691429 #yiv0387691429ygrp-msg p a {font-family:Verdana;}#yiv0387691429 #yiv0387691429ygrp-msg p#yiv0387691429attach-count span {color:#1E66AE;font-weight:700;}#yiv0387691429 #yiv0387691429ygrp-reco #yiv0387691429reco-head {color:#ff7900;font-weight:700;}#yiv0387691429 #yiv0387691429ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ov li a {font-size:130%;text-decoration:none;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0387691429 #yiv0387691429ygrp-sponsor #yiv0387691429ov ul {margin:0;padding:0 0 0 8px;}#yiv0387691429 #yiv0387691429ygrp-text {font-family:Georgia;}#yiv0387691429 #yiv0387691429ygrp-text p {margin:0 0 1em 0;}#yiv0387691429 #yiv0387691429ygrp-text tt {font-size:120%;}#yiv0387691429 #yiv0387691429ygrp-vital ul li:last-child {border-right:none !important;}#yiv0387691429

Thu Jan 14, 2016 11:28 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Maaf, lampirannya ketinggalan.


----- Forwarded Message -----
From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 15 January 2016, 14:25
Subject: Re: [belajar-excel] Disable right click di tab sheet dan menu bar

  Hai Tio,Coba lihat file/folder terlampir,1. Ga bisa diklik kanan dan Cut,Copy ga bisa diPaste2. Folder Ribbon Change yang berisi link untuk membuat menu sendiri serta contoh2nya.
Ini saya dapat dari milis dan internet.
Salam, HK

From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 15 January 2016, 9:26
Subject: [belajar-excel] Disable right click di tab sheet dan menu bar

  Salam Excel Expert, Saya mau bertanya : 1.     Bagaimana code vba untuk disable right click di tab sheet ? 2.     Adakah code vba untuk menon-aktifkan menu bar dan command bar di excel hanya di 1 workbook yang dituju ? dan memunculkan dengan menu sendiri ? Saya sudah cari di google, tapi tidak berhasil-berhasil juga.   Terima kasih bantuannya. Semoga Tuhan YME membalasnya. Amiin.   Salam, Tio  
| | |
| | | |
| | | | |

   

#yiv2267828342 #yiv2267828342 -- #yiv2267828342ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2267828342 #yiv2267828342ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2267828342 #yiv2267828342ygrp-mkp #yiv2267828342hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2267828342 #yiv2267828342ygrp-mkp #yiv2267828342ads {margin-bottom:10px;}#yiv2267828342 #yiv2267828342ygrp-mkp .yiv2267828342ad {padding:0 0;}#yiv2267828342 #yiv2267828342ygrp-mkp .yiv2267828342ad p {margin:0;}#yiv2267828342 #yiv2267828342ygrp-mkp .yiv2267828342ad a {color:#0000ff;text-decoration:none;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ygrp-lc {font-family:Arial;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ygrp-lc #yiv2267828342hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ygrp-lc .yiv2267828342ad {margin-bottom:10px;padding:0 0;}#yiv2267828342 #yiv2267828342actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2267828342 #yiv2267828342activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2267828342 #yiv2267828342activity span {font-weight:700;}#yiv2267828342 #yiv2267828342activity span:first-child {text-transform:uppercase;}#yiv2267828342 #yiv2267828342activity span a {color:#5085b6;text-decoration:none;}#yiv2267828342 #yiv2267828342activity span span {color:#ff7900;}#yiv2267828342 #yiv2267828342activity span .yiv2267828342underline {text-decoration:underline;}#yiv2267828342 .yiv2267828342attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2267828342 .yiv2267828342attach div a {text-decoration:none;}#yiv2267828342 .yiv2267828342attach img {border:none;padding-right:5px;}#yiv2267828342 .yiv2267828342attach label {display:block;margin-bottom:5px;}#yiv2267828342 .yiv2267828342attach label a {text-decoration:none;}#yiv2267828342 blockquote {margin:0 0 0 4px;}#yiv2267828342 .yiv2267828342bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2267828342 .yiv2267828342bold a {text-decoration:none;}#yiv2267828342 dd.yiv2267828342last p a {font-family:Verdana;font-weight:700;}#yiv2267828342 dd.yiv2267828342last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2267828342 dd.yiv2267828342last p span.yiv2267828342yshortcuts {margin-right:0;}#yiv2267828342 div.yiv2267828342attach-table div div a {text-decoration:none;}#yiv2267828342 div.yiv2267828342attach-table {width:400px;}#yiv2267828342 div.yiv2267828342file-title a, #yiv2267828342 div.yiv2267828342file-title a:active, #yiv2267828342 div.yiv2267828342file-title a:hover, #yiv2267828342 div.yiv2267828342file-title a:visited {text-decoration:none;}#yiv2267828342 div.yiv2267828342photo-title a, #yiv2267828342 div.yiv2267828342photo-title a:active, #yiv2267828342 div.yiv2267828342photo-title a:hover, #yiv2267828342 div.yiv2267828342photo-title a:visited {text-decoration:none;}#yiv2267828342 div#yiv2267828342ygrp-mlmsg #yiv2267828342ygrp-msg p a span.yiv2267828342yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2267828342 .yiv2267828342green {color:#628c2a;}#yiv2267828342 .yiv2267828342MsoNormal {margin:0 0 0 0;}#yiv2267828342 o {font-size:0;}#yiv2267828342 #yiv2267828342photos div {float:left;width:72px;}#yiv2267828342 #yiv2267828342photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2267828342 #yiv2267828342photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2267828342 #yiv2267828342reco-category {font-size:77%;}#yiv2267828342 #yiv2267828342reco-desc {font-size:77%;}#yiv2267828342 .yiv2267828342replbq {margin:4px;}#yiv2267828342 #yiv2267828342ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2267828342 #yiv2267828342ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2267828342 #yiv2267828342ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2267828342 #yiv2267828342ygrp-mlmsg select, #yiv2267828342 input, #yiv2267828342 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2267828342 #yiv2267828342ygrp-mlmsg pre, #yiv2267828342 code {font:115% monospace;}#yiv2267828342 #yiv2267828342ygrp-mlmsg * {line-height:1.22em;}#yiv2267828342 #yiv2267828342ygrp-mlmsg #yiv2267828342logo {padding-bottom:10px;}#yiv2267828342 #yiv2267828342ygrp-msg p a {font-family:Verdana;}#yiv2267828342 #yiv2267828342ygrp-msg p#yiv2267828342attach-count span {color:#1E66AE;font-weight:700;}#yiv2267828342 #yiv2267828342ygrp-reco #yiv2267828342reco-head {color:#ff7900;font-weight:700;}#yiv2267828342 #yiv2267828342ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ov li a {font-size:130%;text-decoration:none;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2267828342 #yiv2267828342ygrp-sponsor #yiv2267828342ov ul {margin:0;padding:0 0 0 8px;}#yiv2267828342 #yiv2267828342ygrp-text {font-family:Georgia;}#yiv2267828342 #yiv2267828342ygrp-text p {margin:0 0 1em 0;}#yiv2267828342 #yiv2267828342ygrp-text tt {font-size:120%;}#yiv2267828342 #yiv2267828342ygrp-vital ul li:last-child {border-right:none !important;}#yiv2267828342

Fri Jan 15, 2016 12:41 am (PST) . Posted by:

"Tio Adi Bayu Adjie"

Terima kasih mas Tobykenzo,
Saya pakai cara ini :

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

Tetapi tetap tidak berhasil, kira-kira adakah yg perlu diperbaiki ?

Terima kasih.





From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Friday, January 15, 2016 1:12 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Re: Disable right click di tab sheet dan menu bar



Dear Tio,



1. Gunakan method "Worksheet_BeforeRightClick"

Untuk meng non aktifkan yg lain gunakan method Application.OnKeys

2. Gunakan Custom UI Editor (sdh pernah di bahas di forum ini) untuk meng non aktifkan beberapa custom Ribbon



TerimaKasih.

Fri Jan 15, 2016 12:41 am (PST) . Posted by:

"Tio Adi Bayu Adjie"

Pak Hendrik, kok tidak ada lampirannya yah ? Maaf.

Best Regards,
Tio Adi Bayu Adjie
Technical Support Business Services
PT. SANGGAR SARANA BAJA
THE GARDEN CENTRE LT. 5 Suite #.519
Cilandak Commercial Estate
Jl. Raya Cilandak KKO Jakarta 12560
Telp : (021) 29976830 ext. 5254
Fax : Telp : (021) 29976835
Mobile : 082125577485
Email : tio.adjie@ptssb.co.id<mailto:stefany.muller@ptssb.co.id>

[Think Green]

[Foto all unit]

[Logo SSB]




From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Friday, January 15, 2016 2:25 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Disable right click di tab sheet dan menu bar


Hai Tio,
Coba lihat file/folder terlampir,
1. Ga bisa diklik kanan dan Cut,Copy ga bisa diPaste
2. Folder Ribbon Change yang berisi link untuk membuat menu sendiri serta contoh2nya.

Ini saya dapat dari milis dan internet.

Salam,
HK
________________________________
From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id<mailto:tio.adjie@ptssb.co.id> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Sent: Friday, 15 January 2016, 9:26
Subject: [belajar-excel] Disable right click di tab sheet dan menu bar


Salam Excel Expert,
Saya mau bertanya :
1. Bagaimana code vba untuk disable right click di tab sheet ?
2. Adakah code vba untuk menon-aktifkan menu bar dan command bar di excel hanya di 1 workbook yang dituju ? dan memunculkan dengan menu sendiri ?
Saya sudah cari di google, tapi tidak berhasil-berhasil juga.

Terima kasih bantuannya. Semoga Tuhan YME membalasnya.
Amiin.

Salam,
Tio








Thu Jan 14, 2016 10:17 pm (PST) . Posted by:

tobykenzo

Dear Annas,


Coba file ini.
File ini menggunakan VBA dengan aplikasi Split, tinggal di klik aja nana2 yang ada di kolom B.


TerimaKasih.

Thu Jan 14, 2016 10:26 pm (PST) . Posted by:

tobykenzo

Dear Boyo,


Coba File ini.
File ini menggunakan VBA, jadi aktifkan dulu Enable macronya..


TerimaKasih.

Thu Jan 14, 2016 11:17 pm (PST) . Posted by:

"Haris Kartiwan"

Dear Mr Kid,

tidak ada yg vertical, Mr Kid.

Memang file ini lah yg kita gunakan.

Selanjutnya para staff minta laporan absensi, jadinya kita buat seperti di sheet A (nama staff), nanti selanjutnya akan kita email sheet tsb ke staff masing2x.

Saya sudah coba2x untuk buat formulanya di sheet "A" tapi hasilnya tdk sesuai.

Mohon Bantuannya Mr Kid.

Apakah ada ide/bentuk lain (vertical) untuk sheet Tabel?, yg nantinya akan mempermudah pembuatan sheet "staff".

Dan jika ada, bisa kami pertimbangkan dan cocok, akan kita pakai.

Terima Kasih

Haris Kartiwan

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Friday, January 15, 2016 9:34 AM
To: BeExcel
Subject: Re: FW: [belajar-excel] Menghitung OT dan Late Absensi perminggu

Hai Haris,

Tabel sumber datanya ada yang tersusun vertikal tidak ya ?

Jadi, tabelnya hanya ada 1 dengan header :

Nama, Tanggal, In, Out, Roster, Noted, Late, Over Work, Early

Kalau ada, boleh dikirim ke milis kan ya...

Regards,

Kid

2016-01-13 14:46 GMT+07:00 'Haris Kartiwan' hkartiwan@arahrestu.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Dear BeExceller,

Saya mencoba menggunakan rumus à =SUMIFS(Tabel!B10:FB10;Tabel!B7:FB7;"Late";Tabel!B6:FE6;"<=04/01/2016") di Cell B7 Sheet AB. Tapi hasilnya #Value!

Kira2x ada yg kurang di formula itu ngak yeahh, atau para teman2x exceller ada ide lain?

Terima Kasih

Haris

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 11 Januari 2016 18:52
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghitung OT dan Late Absensi perminggu [1 Attachment]

Dear Para Master Excel

Saya mempunyai file Absensi dalam 1 Bulan (file Terlampir), dan telah berjalan dengan baik.

Sekarang ada pemintaan dari staff, laporan absensi mingguan, output nya seperti di sheet AB.

Minggu I 0:00 di dapat dari sheet table dr tanggal 1 – 2 januari

Minggu II 0:33 di dapat dari sheet table dr tanggal 4 – 9 januari

Dst..

Mohon bantuannya para teman..

Sebelumnya Terima Kasih

Salam

Haris

_____

<https://www.avast.com/antivirus>

This email is free from viruses and malware because avast! Antivirus <https://www.avast.com/antivirus> protection is active.

_____

<https://www.avast.com/antivirus>

This email is free from viruses and malware because avast! Antivirus <https://www.avast.com/antivirus> protection is active.

---
This email is free from viruses and malware because avast! Antivirus protection is active.
https://www.avast.com/antivirus

Fri Jan 15, 2016 2:07 am (PST) . Posted by:

"anas hasbullah" hasbullah_anas

Thank you master kid :D
sesuai dg kebutuhan, mantabb

Pada Jumat, 15 Januari 2016 9:22, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear BeExceller,

Kasus split text yang ada di dalam topik bernama 'cari data' yang diajukan oleh Saudara Anas Hasbullah, bisa diselesaikan dengan membuat formula per bagian teks yang akan dipisahkan.

Contoh penyelesaian kasus seperti ini bisa diunduh pada link yang tersedia dibawah sana.

----------------------------------------------------------
Catatan :
----------------------------------------------------------
Ketika topik yang akan dikirim ke milis adalah topik baru DAN BUKAN melanjutkan topik yang sudah ada, maka dimohon dengan sangat agar membuat topik baru dengan cara :
1. Login akun email yang Anda daftarkan ke milis.
2. Buat email baru ( Compose new email )
3. Isi bagian To (email tujuan) dengan akun email milis, yaitu :
belajar-excel@yahoogroups.com

4. Isi bagian Subject (judul email) dengan kalimat singkat yang mencerminkan kasus yang diutarakan.
5. Isi bagian Body Email (batang tubuh email) dengan kalimat yang menjabarkan kasus yang diutarakan.
6. [Bila Perlu] Lampirkan file contoh data (MAKSIMUM 250KB, karena hanya berisi contoh data dan bukan data kerja)
7. JANGAN re-post (posting ulang) jika belum mencapai 3 x 24 jam dari posting terakhir, karena ada proses moderasi dan tidak semua member yang sedang online bisa menyelesaikan kasus yang diutarakan.

8. Mohon hal ini agar diindahkan, sehingga tidak terulang kembali kejadian seperti di bawah ini : 
[Saudara Anas melakukan posting dengan isi email yang berbeda sama sekali dengan saudara Imam. Padahal topik bernama 'cari data' adalah topik yang diajukan oleh saudara Imam]

On Wed, Jan 13, 2016 at 7:00 PM, anas hasbullah hasbullah_anas@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
  dear master excel
saya minta bantuan mengenai rumus yg valueberikut kami lampirkan filnya

Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
----------------------------------------------------------

File lampiran bisa diunduh disini.
#yiv9473308732 #yiv9473308732 -- #yiv9473308732ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9473308732 #yiv9473308732ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9473308732 #yiv9473308732ygrp-mkp #yiv9473308732hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9473308732 #yiv9473308732ygrp-mkp #yiv9473308732ads {margin-bottom:10px;}#yiv9473308732 #yiv9473308732ygrp-mkp .yiv9473308732ad {padding:0 0;}#yiv9473308732 #yiv9473308732ygrp-mkp .yiv9473308732ad p {margin:0;}#yiv9473308732 #yiv9473308732ygrp-mkp .yiv9473308732ad a {color:#0000ff;text-decoration:none;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ygrp-lc {font-family:Arial;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ygrp-lc #yiv9473308732hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ygrp-lc .yiv9473308732ad {margin-bottom:10px;padding:0 0;}#yiv9473308732 #yiv9473308732actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9473308732 #yiv9473308732activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9473308732 #yiv9473308732activity span {font-weight:700;}#yiv9473308732 #yiv9473308732activity span:first-child {text-transform:uppercase;}#yiv9473308732 #yiv9473308732activity span a {color:#5085b6;text-decoration:none;}#yiv9473308732 #yiv9473308732activity span span {color:#ff7900;}#yiv9473308732 #yiv9473308732activity span .yiv9473308732underline {text-decoration:underline;}#yiv9473308732 .yiv9473308732attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9473308732 .yiv9473308732attach div a {text-decoration:none;}#yiv9473308732 .yiv9473308732attach img {border:none;padding-right:5px;}#yiv9473308732 .yiv9473308732attach label {display:block;margin-bottom:5px;}#yiv9473308732 .yiv9473308732attach label a {text-decoration:none;}#yiv9473308732 blockquote {margin:0 0 0 4px;}#yiv9473308732 .yiv9473308732bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9473308732 .yiv9473308732bold a {text-decoration:none;}#yiv9473308732 dd.yiv9473308732last p a {font-family:Verdana;font-weight:700;}#yiv9473308732 dd.yiv9473308732last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9473308732 dd.yiv9473308732last p span.yiv9473308732yshortcuts {margin-right:0;}#yiv9473308732 div.yiv9473308732attach-table div div a {text-decoration:none;}#yiv9473308732 div.yiv9473308732attach-table {width:400px;}#yiv9473308732 div.yiv9473308732file-title a, #yiv9473308732 div.yiv9473308732file-title a:active, #yiv9473308732 div.yiv9473308732file-title a:hover, #yiv9473308732 div.yiv9473308732file-title a:visited {text-decoration:none;}#yiv9473308732 div.yiv9473308732photo-title a, #yiv9473308732 div.yiv9473308732photo-title a:active, #yiv9473308732 div.yiv9473308732photo-title a:hover, #yiv9473308732 div.yiv9473308732photo-title a:visited {text-decoration:none;}#yiv9473308732 div#yiv9473308732ygrp-mlmsg #yiv9473308732ygrp-msg p a span.yiv9473308732yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9473308732 .yiv9473308732green {color:#628c2a;}#yiv9473308732 .yiv9473308732MsoNormal {margin:0 0 0 0;}#yiv9473308732 o {font-size:0;}#yiv9473308732 #yiv9473308732photos div {float:left;width:72px;}#yiv9473308732 #yiv9473308732photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9473308732 #yiv9473308732photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9473308732 #yiv9473308732reco-category {font-size:77%;}#yiv9473308732 #yiv9473308732reco-desc {font-size:77%;}#yiv9473308732 .yiv9473308732replbq {margin:4px;}#yiv9473308732 #yiv9473308732ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9473308732 #yiv9473308732ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9473308732 #yiv9473308732ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9473308732 #yiv9473308732ygrp-mlmsg select, #yiv9473308732 input, #yiv9473308732 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9473308732 #yiv9473308732ygrp-mlmsg pre, #yiv9473308732 code {font:115% monospace;}#yiv9473308732 #yiv9473308732ygrp-mlmsg * {line-height:1.22em;}#yiv9473308732 #yiv9473308732ygrp-mlmsg #yiv9473308732logo {padding-bottom:10px;}#yiv9473308732 #yiv9473308732ygrp-msg p a {font-family:Verdana;}#yiv9473308732 #yiv9473308732ygrp-msg p#yiv9473308732attach-count span {color:#1E66AE;font-weight:700;}#yiv9473308732 #yiv9473308732ygrp-reco #yiv9473308732reco-head {color:#ff7900;font-weight:700;}#yiv9473308732 #yiv9473308732ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ov li a {font-size:130%;text-decoration:none;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9473308732 #yiv9473308732ygrp-sponsor #yiv9473308732ov ul {margin:0;padding:0 0 0 8px;}#yiv9473308732 #yiv9473308732ygrp-text {font-family:Georgia;}#yiv9473308732 #yiv9473308732ygrp-text p {margin:0 0 1em 0;}#yiv9473308732 #yiv9473308732ygrp-text tt {font-size:120%;}#yiv9473308732 #yiv9473308732ygrp-vital ul li:last-child {border-right:none !important;}#yiv9473308732

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar