[belajar-excel] Digest Number 4164

Milis Belajar Microsoft Excel Group

15 Messages

Digest #4164

1

ambil range acuan by "Fahmi Syaifullah" fahmisyaifullah20

2a

Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa by "M.Ade Alfarid" aderyo

2b

Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bis by "misbahul munir"

2c

Re: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak by "hendrik karnadi" hendrikkarnadi

2d

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b by "M.Ade Alfarid" aderyo

2e

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b by "Matzen, M. (Matzen)"

2f

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b by "hendrik karnadi" hendrikkarnadi

2g

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b by "M.Ade Alfarid" aderyo

3a

Re: Tidak bisa record macro by "Heru Safrudin" heru.safrudin

4a

Sheet di protect macro tidak jalan by "farud oke"

4b

Re: Sheet di protect macro tidak jalan by "hendrik karnadi" hendrikkarnadi

4c

Re: Sheet di protect macro tidak jalan by "Matzen, M. (Matzen)"

4d

Re: Sheet di protect macro tidak jalan by "nangagus"

4e

Re: Sheet di protect macro tidak jalan by "farud oke"

5

http://info.yahoo.com/legal/us/yahoo/utos/terms/ by

Messages

1

ambil range acuan

Mon Apr 24, 2017 7:49 pm (PDT) . Posted by:

"Fahmi Syaifullah" fahmisyaifullah20

assalamu'alaikum Wr.Wb
BeExeller yang baik hati, mau tanya
saya membuat suatu coding VBA seperti ini
Dim range1 As Range
Dim range2 As Integer    Range("A1", Range("A1").End(xlDown)).Select
    Set range1 = Selection.Offset(1, 0).Select    range2 = ....
  
jadi ingin saya itu adalah mengambil baris sih A yang sudah di End dan yang sudah di Offsetcontoh karna sudah di Offset menjadi cell A88 nah saya ingin mengambil angka 88 itu kemudian di tambah dengan 20 dan supaya nanti rangeA88:A108 saya proses hidden (angka 20 itu selalu menetap karna admin lain selalu menampilkan header tambahan dengan mengcocy tabel diatasnya jadi selalu sama tabel atas dengan tabel bawah) dalam satu worksheet bisa ada 30 tabel maklum deh adminnya belum tau kaedah database yang benar.

mohon bantuannya BeExceller sekalian.
Terima Kasih,wassalamu'alaikum Wr.WbFahmi

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa

Mon Apr 24, 2017 9:00 pm (PDT) . Posted by:

"M.Ade Alfarid" aderyo

Dear Bexcelers,

Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa
dihapus,tidak bisa diedit).

Sepengetahuan saya yang bisa terproteksi hanya worksheet saja.

Ade

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2b

Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bis

Mon Apr 24, 2017 9:31 pm (PDT) . Posted by:

"misbahul munir"

ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas


Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Bexcelers, Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit).Sepengetahuan saya yang bisa terproteksi hanya worksheet saja. Ade #yiv0195531379 #yiv0195531379 -- #yiv0195531379ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0195531379 #yiv0195531379ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0195531379 #yiv0195531379ygrp-mkp #yiv0195531379hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0195531379 #yiv0195531379ygrp-mkp #yiv0195531379ads {margin-bottom:10px;}#yiv0195531379 #yiv0195531379ygrp-mkp .yiv0195531379ad {padding:0 0;}#yiv0195531379 #yiv0195531379ygrp-mkp .yiv0195531379ad p {margin:0;}#yiv0195531379 #yiv0195531379ygrp-mkp .yiv0195531379ad a {color:#0000ff;text-decoration:none;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ygrp-lc {font-family:Arial;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ygrp-lc #yiv0195531379hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ygrp-lc .yiv0195531379ad {margin-bottom:10px;padding:0 0;}#yiv0195531379 #yiv0195531379actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0195531379 #yiv0195531379activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0195531379 #yiv0195531379activity span {font-weight:700;}#yiv0195531379 #yiv0195531379activity span:first-child {text-transform:uppercase;}#yiv0195531379 #yiv0195531379activity span a {color:#5085b6;text-decoration:none;}#yiv0195531379 #yiv0195531379activity span span {color:#ff7900;}#yiv0195531379 #yiv0195531379activity span .yiv0195531379underline {text-decoration:underline;}#yiv0195531379 .yiv0195531379attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0195531379 .yiv0195531379attach div a {text-decoration:none;}#yiv0195531379 .yiv0195531379attach img {border:none;padding-right:5px;}#yiv0195531379 .yiv0195531379attach label {display:block;margin-bottom:5px;}#yiv0195531379 .yiv0195531379attach label a {text-decoration:none;}#yiv0195531379 blockquote {margin:0 0 0 4px;}#yiv0195531379 .yiv0195531379bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0195531379 .yiv0195531379bold a {text-decoration:none;}#yiv0195531379 dd.yiv0195531379last p a {font-family:Verdana;font-weight:700;}#yiv0195531379 dd.yiv0195531379last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0195531379 dd.yiv0195531379last p span.yiv0195531379yshortcuts {margin-right:0;}#yiv0195531379 div.yiv0195531379attach-table div div a {text-decoration:none;}#yiv0195531379 div.yiv0195531379attach-table {width:400px;}#yiv0195531379 div.yiv0195531379file-title a, #yiv0195531379 div.yiv0195531379file-title a:active, #yiv0195531379 div.yiv0195531379file-title a:hover, #yiv0195531379 div.yiv0195531379file-title a:visited {text-decoration:none;}#yiv0195531379 div.yiv0195531379photo-title a, #yiv0195531379 div.yiv0195531379photo-title a:active, #yiv0195531379 div.yiv0195531379photo-title a:hover, #yiv0195531379 div.yiv0195531379photo-title a:visited {text-decoration:none;}#yiv0195531379 div#yiv0195531379ygrp-mlmsg #yiv0195531379ygrp-msg p a span.yiv0195531379yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0195531379 .yiv0195531379green {color:#628c2a;}#yiv0195531379 .yiv0195531379MsoNormal {margin:0 0 0 0;}#yiv0195531379 o {font-size:0;}#yiv0195531379 #yiv0195531379photos div {float:left;width:72px;}#yiv0195531379 #yiv0195531379photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0195531379 #yiv0195531379photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0195531379 #yiv0195531379reco-category {font-size:77%;}#yiv0195531379 #yiv0195531379reco-desc {font-size:77%;}#yiv0195531379 .yiv0195531379replbq {margin:4px;}#yiv0195531379 #yiv0195531379ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0195531379 #yiv0195531379ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0195531379 #yiv0195531379ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0195531379 #yiv0195531379ygrp-mlmsg select, #yiv0195531379 input, #yiv0195531379 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0195531379 #yiv0195531379ygrp-mlmsg pre, #yiv0195531379 code {font:115% monospace;}#yiv0195531379 #yiv0195531379ygrp-mlmsg * {line-height:1.22em;}#yiv0195531379 #yiv0195531379ygrp-mlmsg #yiv0195531379logo {padding-bottom:10px;}#yiv0195531379 #yiv0195531379ygrp-msg p a {font-family:Verdana;}#yiv0195531379 #yiv0195531379ygrp-msg p#yiv0195531379attach-count span {color:#1E66AE;font-weight:700;}#yiv0195531379 #yiv0195531379ygrp-reco #yiv0195531379reco-head {color:#ff7900;font-weight:700;}#yiv0195531379 #yiv0195531379ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ov li a {font-size:130%;text-decoration:none;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0195531379 #yiv0195531379ygrp-sponsor #yiv0195531379ov ul {margin:0;padding:0 0 0 8px;}#yiv0195531379 #yiv0195531379ygrp-text {font-family:Georgia;}#yiv0195531379 #yiv0195531379ygrp-text p {margin:0 0 1em 0;}#yiv0195531379 #yiv0195531379ygrp-text tt {font-size:120%;}#yiv0195531379 #yiv0195531379ygrp-vital ul li:last-child {border-right:none !important;}#yiv0195531379

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2c

Re: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak

Mon Apr 24, 2017 9:58 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba copas macro ini di Sheet1(Sheet1) VBE SheetOption ExplicitPrivate Sub Worksheet_Change(ByVal Target As Range)
    Dim Rng As String    If Target.Address = "$A$1" Then        Range("8:127").EntireRow.Hidden = False        Rng = Range("A1").Value + 8 & ":127"        Rows(Rng).EntireRow.Hidden = True    End IfEnd Sub
Salam,HK
From: "misbahul munir misbach_13@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 25 April 2017, 11:31
Subject: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]

  ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas


Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Bexcelers, Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit).Sepengetahuan saya yang bisa terproteksi hanya worksheet saja. Ade

#yiv3454319311 #yiv3454319311 -- #yiv3454319311ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3454319311 #yiv3454319311ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3454319311 #yiv3454319311ygrp-mkp #yiv3454319311hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3454319311 #yiv3454319311ygrp-mkp #yiv3454319311ads {margin-bottom:10px;}#yiv3454319311 #yiv3454319311ygrp-mkp .yiv3454319311ad {padding:0 0;}#yiv3454319311 #yiv3454319311ygrp-mkp .yiv3454319311ad p {margin:0;}#yiv3454319311 #yiv3454319311ygrp-mkp .yiv3454319311ad a {color:#0000ff;text-decoration:none;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ygrp-lc {font-family:Arial;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ygrp-lc #yiv3454319311hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ygrp-lc .yiv3454319311ad {margin-bottom:10px;padding:0 0;}#yiv3454319311 #yiv3454319311actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3454319311 #yiv3454319311activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3454319311 #yiv3454319311activity span {font-weight:700;}#yiv3454319311 #yiv3454319311activity span:first-child {text-transform:uppercase;}#yiv3454319311 #yiv3454319311activity span a {color:#5085b6;text-decoration:none;}#yiv3454319311 #yiv3454319311activity span span {color:#ff7900;}#yiv3454319311 #yiv3454319311activity span .yiv3454319311underline {text-decoration:underline;}#yiv3454319311 .yiv3454319311attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3454319311 .yiv3454319311attach div a {text-decoration:none;}#yiv3454319311 .yiv3454319311attach img {border:none;padding-right:5px;}#yiv3454319311 .yiv3454319311attach label {display:block;margin-bottom:5px;}#yiv3454319311 .yiv3454319311attach label a {text-decoration:none;}#yiv3454319311 blockquote {margin:0 0 0 4px;}#yiv3454319311 .yiv3454319311bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3454319311 .yiv3454319311bold a {text-decoration:none;}#yiv3454319311 dd.yiv3454319311last p a {font-family:Verdana;font-weight:700;}#yiv3454319311 dd.yiv3454319311last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3454319311 dd.yiv3454319311last p span.yiv3454319311yshortcuts {margin-right:0;}#yiv3454319311 div.yiv3454319311attach-table div div a {text-decoration:none;}#yiv3454319311 div.yiv3454319311attach-table {width:400px;}#yiv3454319311 div.yiv3454319311file-title a, #yiv3454319311 div.yiv3454319311file-title a:active, #yiv3454319311 div.yiv3454319311file-title a:hover, #yiv3454319311 div.yiv3454319311file-title a:visited {text-decoration:none;}#yiv3454319311 div.yiv3454319311photo-title a, #yiv3454319311 div.yiv3454319311photo-title a:active, #yiv3454319311 div.yiv3454319311photo-title a:hover, #yiv3454319311 div.yiv3454319311photo-title a:visited {text-decoration:none;}#yiv3454319311 div#yiv3454319311ygrp-mlmsg #yiv3454319311ygrp-msg p a span.yiv3454319311yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3454319311 .yiv3454319311green {color:#628c2a;}#yiv3454319311 .yiv3454319311MsoNormal {margin:0 0 0 0;}#yiv3454319311 o {font-size:0;}#yiv3454319311 #yiv3454319311photos div {float:left;width:72px;}#yiv3454319311 #yiv3454319311photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3454319311 #yiv3454319311photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3454319311 #yiv3454319311reco-category {font-size:77%;}#yiv3454319311 #yiv3454319311reco-desc {font-size:77%;}#yiv3454319311 .yiv3454319311replbq {margin:4px;}#yiv3454319311 #yiv3454319311ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3454319311 #yiv3454319311ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3454319311 #yiv3454319311ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3454319311 #yiv3454319311ygrp-mlmsg select, #yiv3454319311 input, #yiv3454319311 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3454319311 #yiv3454319311ygrp-mlmsg pre, #yiv3454319311 code {font:115% monospace;}#yiv3454319311 #yiv3454319311ygrp-mlmsg * {line-height:1.22em;}#yiv3454319311 #yiv3454319311ygrp-mlmsg #yiv3454319311logo {padding-bottom:10px;}#yiv3454319311 #yiv3454319311ygrp-msg p a {font-family:Verdana;}#yiv3454319311 #yiv3454319311ygrp-msg p#yiv3454319311attach-count span {color:#1E66AE;font-weight:700;}#yiv3454319311 #yiv3454319311ygrp-reco #yiv3454319311reco-head {color:#ff7900;font-weight:700;}#yiv3454319311 #yiv3454319311ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ov li a {font-size:130%;text-decoration:none;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3454319311 #yiv3454319311ygrp-sponsor #yiv3454319311ov ul {margin:0;padding:0 0 0 8px;}#yiv3454319311 #yiv3454319311ygrp-text {font-family:Georgia;}#yiv3454319311 #yiv3454319311ygrp-text p {margin:0 0 1em 0;}#yiv3454319311 #yiv3454319311ygrp-text tt {font-size:120%;}#yiv3454319311 #yiv3454319311ygrp-vital ul li:last-child {border-right:none !important;}#yiv3454319311

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2d

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b

Mon Apr 24, 2017 11:49 pm (PDT) . Posted by:

"M.Ade Alfarid" aderyo

Thanks responnya

Bukan terhidden mas,

Tapi terlihat,tidak bisa diedit,tidak bisa dihapus dll

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Tuesday, April 25, 2017 11:10 AM
*To:* belajar-excel@yahoogroups.com
*Subject:* Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak
bisa dihapus,tidak bisa diedit) [1 Attachment]

ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas

Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Bexcelers,

Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa
dihapus,tidak bisa diedit).

Sepengetahuan saya yang bisa terproteksi hanya worksheet saja.

Ade

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2e

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b

Mon Apr 24, 2017 11:59 pm (PDT) . Posted by:

"Matzen, M. (Matzen)"

Seingat saya default protect cell itu adalah locked, dan ketika protect sheet di aktifkan maka semua cell yang ada didalam sheet itu akan terprotect, dan jika ada cell yang tetap bisa di edit maka status cell locked nya di lepas centangnya, baru di protect kembali dengan status protect nya sellected protect cell ya di lepas centangnya


Terima Kasih

Matzen

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 25 April 2017 13:45
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)


Thanks responnya

Bukan terhidden mas,
Tapi terlihat,tidak bisa diedit,tidak bisa dihapus dll

From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>]
Sent: Tuesday, April 25, 2017 11:10 AM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]


ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas

Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id<mailto:QA@kkmi.co.id> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> menulis:


Dear Bexcelers,

Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit).
Sepengetahuan saya yang bisa terproteksi hanya worksheet saja.

Ade



__________________________________________________________
This email has been scanned by AkzoNobel for Viruses and Spam.
For more information please contact your local IT Service Desk.
__________________________________________________________

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2f

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b

Tue Apr 25, 2017 12:38 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba copas macro ini di Sheet1(Sheet1) VBE Sheet,Private Sub Worksheet_Change(ByVal Target As Range)    ActiveSheet.Unprotect    Cells.Locked = False    Range("A" & Range("A1").Value + 8 & ":J127").Locked = True    ActiveSheet.ProtectEnd Sub
Salam,HK

From: "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 25 April 2017, 13:49
Subject: RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

  Thanks responnya Bukan terhidden mas,Tapi terlihat,tidak bisa diedit,tidak bisa dihapus dll From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, April 25, 2017 11:10 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]   ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:   Dear Bexcelers, Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit).Sepengetahuan saya yang bisa terproteksi hanya worksheet saja. Ade  #yiv5142407818 #yiv5142407818 -- #yiv5142407818ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5142407818 #yiv5142407818ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5142407818 #yiv5142407818ygrp-mkp #yiv5142407818hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5142407818 #yiv5142407818ygrp-mkp #yiv5142407818ads {margin-bottom:10px;}#yiv5142407818 #yiv5142407818ygrp-mkp .yiv5142407818ad {padding:0 0;}#yiv5142407818 #yiv5142407818ygrp-mkp .yiv5142407818ad p {margin:0;}#yiv5142407818 #yiv5142407818ygrp-mkp .yiv5142407818ad a {color:#0000ff;text-decoration:none;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ygrp-lc {font-family:Arial;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ygrp-lc #yiv5142407818hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ygrp-lc .yiv5142407818ad {margin-bottom:10px;padding:0 0;}#yiv5142407818 #yiv5142407818actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5142407818 #yiv5142407818activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5142407818 #yiv5142407818activity span {font-weight:700;}#yiv5142407818 #yiv5142407818activity span:first-child {text-transform:uppercase;}#yiv5142407818 #yiv5142407818activity span a {color:#5085b6;text-decoration:none;}#yiv5142407818 #yiv5142407818activity span span {color:#ff7900;}#yiv5142407818 #yiv5142407818activity span .yiv5142407818underline {text-decoration:underline;}#yiv5142407818 .yiv5142407818attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5142407818 .yiv5142407818attach div a {text-decoration:none;}#yiv5142407818 .yiv5142407818attach img {border:none;padding-right:5px;}#yiv5142407818 .yiv5142407818attach label {display:block;margin-bottom:5px;}#yiv5142407818 .yiv5142407818attach label a {text-decoration:none;}#yiv5142407818 blockquote {margin:0 0 0 4px;}#yiv5142407818 .yiv5142407818bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5142407818 .yiv5142407818bold a {text-decoration:none;}#yiv5142407818 dd.yiv5142407818last p a {font-family:Verdana;font-weight:700;}#yiv5142407818 dd.yiv5142407818last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5142407818 dd.yiv5142407818last p span.yiv5142407818yshortcuts {margin-right:0;}#yiv5142407818 div.yiv5142407818attach-table div div a {text-decoration:none;}#yiv5142407818 div.yiv5142407818attach-table {width:400px;}#yiv5142407818 div.yiv5142407818file-title a, #yiv5142407818 div.yiv5142407818file-title a:active, #yiv5142407818 div.yiv5142407818file-title a:hover, #yiv5142407818 div.yiv5142407818file-title a:visited {text-decoration:none;}#yiv5142407818 div.yiv5142407818photo-title a, #yiv5142407818 div.yiv5142407818photo-title a:active, #yiv5142407818 div.yiv5142407818photo-title a:hover, #yiv5142407818 div.yiv5142407818photo-title a:visited {text-decoration:none;}#yiv5142407818 div#yiv5142407818ygrp-mlmsg #yiv5142407818ygrp-msg p a span.yiv5142407818yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5142407818 .yiv5142407818green {color:#628c2a;}#yiv5142407818 .yiv5142407818MsoNormal {margin:0 0 0 0;}#yiv5142407818 o {font-size:0;}#yiv5142407818 #yiv5142407818photos div {float:left;width:72px;}#yiv5142407818 #yiv5142407818photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5142407818 #yiv5142407818photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5142407818 #yiv5142407818reco-category {font-size:77%;}#yiv5142407818 #yiv5142407818reco-desc {font-size:77%;}#yiv5142407818 .yiv5142407818replbq {margin:4px;}#yiv5142407818 #yiv5142407818ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5142407818 #yiv5142407818ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5142407818 #yiv5142407818ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5142407818 #yiv5142407818ygrp-mlmsg select, #yiv5142407818 input, #yiv5142407818 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5142407818 #yiv5142407818ygrp-mlmsg pre, #yiv5142407818 code {font:115% monospace;}#yiv5142407818 #yiv5142407818ygrp-mlmsg * {line-height:1.22em;}#yiv5142407818 #yiv5142407818ygrp-mlmsg #yiv5142407818logo {padding-bottom:10px;}#yiv5142407818 #yiv5142407818ygrp-msg p a {font-family:Verdana;}#yiv5142407818 #yiv5142407818ygrp-msg p#yiv5142407818attach-count span {color:#1E66AE;font-weight:700;}#yiv5142407818 #yiv5142407818ygrp-reco #yiv5142407818reco-head {color:#ff7900;font-weight:700;}#yiv5142407818 #yiv5142407818ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ov li a {font-size:130%;text-decoration:none;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5142407818 #yiv5142407818ygrp-sponsor #yiv5142407818ov ul {margin:0;padding:0 0 0 8px;}#yiv5142407818 #yiv5142407818ygrp-text {font-family:Georgia;}#yiv5142407818 #yiv5142407818ygrp-text p {margin:0 0 1em 0;}#yiv5142407818 #yiv5142407818ygrp-text tt {font-size:120%;}#yiv5142407818 #yiv5142407818ygrp-vital ul li:last-child {border-right:none !important;}#yiv5142407818

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2g

Re: Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak b

Tue Apr 25, 2017 1:18 am (PDT) . Posted by:

"M.Ade Alfarid" aderyo

Dear master hendrik,

Thanks responnya,

Untuk kasus ini, tidaklah langsung semua cell terproteksi.

Setiap cell hanya terproteksi jika telah diinput karakter.

Dan tabel bisa bertambah sampai ribuan data.

Jadi yang belum terinput tidak terproteksi.

Sebelum eksekusi enter input, mungkin muncul notifikasi peringatan "apakah
sudah OKE?" OK/Cancel.

Nah jika sudah selesai input satu cell yg telah diinput saja yang
terproteksi.

Mohon penerangan dan bimbingan.

Ade

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Tuesday, April 25, 2017 2:39 PM
*To:* belajar-excel@yahoogroups.com
*Subject:* Re: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak
bisa dihapus,tidak bisa diedit)

Coba copas macro ini di Sheet1(Sheet1) VBE Sheet,

Private Sub Worksheet_Change(ByVal Target As Range)

ActiveSheet.Unprotect

Cells.Locked = False

Range("A" & Range("A1").Value + 8 & ":J127").Locked = True

ActiveSheet.Protect

End Sub

Salam,

HK
------------------------------

*From:* "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <
belajar-excel@yahoogroups.com>
*To:* belajar-excel@yahoogroups.com
*Sent:* Tuesday, 25 April 2017, 13:49
*Subject:* RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak
bisa dihapus,tidak bisa diedit)

Thanks responnya

Bukan terhidden mas,

Tapi terlihat,tidak bisa diedit,tidak bisa dihapus dll

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Tuesday, April 25, 2017 11:10 AM
*To:* belajar-excel@yahoogroups.com
*Subject:* Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak
bisa dihapus,tidak bisa diedit) [1 Attachment]

ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas

Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' QA@kkmi.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Bexcelers,

Apakah memungkinkan jika setelah Input,cell otomatis terkunci (tidak bisa
dihapus,tidak bisa diedit).

Sepengetahuan saya yang bisa terproteksi hanya worksheet saja.

Ade

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

3a

Re: Tidak bisa record macro

Mon Apr 24, 2017 9:30 pm (PDT) . Posted by:

"Heru Safrudin" heru.safrudin

SubhanAllah…..

Bisa ya…

Terima kasih Mr.

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 21 April 2017 17:09
To: BeExcel
Subject: Re: [belajar-excel] Tidak bisa record macro

hmmm....

gini aja deh...

Coba file yang ada disini <https://app.box.com/s/nnzsu5cb26a89oi4bzymkyrt5wu0eyrv> dipelajari dan kemudian dikembangkan sesuai kebutuhan.

Regards,

Kid

2017-04-21 9:36 GMT+07:00 'Heru Safrudin' fcprocessing.bisikediri@bisi.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

Aduh sayang sekali…..

Mr. bisakah minta contoh macro untuk membuat silsilah keluarga semacam contoh berikut:

Misal kita mau nambah cabang tinggal klik kotak yang dimaksud otomatis keluar cabang.

Bagaimana penulisan kodenya

Mohon petunjuknya

Terima kasih

Heru Safrudin

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 20 April 2017 9:54
To: BeExcel
Subject: Re: [belajar-excel] Tidak bisa record macro

Hai Heru,

Excel 2003 dan Excel 2010 ke atas bisa record macro shapes.
Excel 2007 memang tidak bisa record macro shapes dan harus ditulis sendiri baris-baris kodenya. Excel VBA Help bagian Excel Object Model Reference.

Regards,

Kid

2017-04-20 9:07 GMT+07:00 'Heru Safrudin' fcprocessing.bisikediri@bisi.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

Dear B-Exceller,

Kenapa Excel 2007 tidak merekam macro Insert shape atau object lain ya? Padahal Excel 2003 bisa

Mohon penjelasannya

Terima kasih

Heru Safrudin

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4a

Sheet di protect macro tidak jalan

Mon Apr 24, 2017 9:30 pm (PDT) . Posted by:

"farud oke"

Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula
jalan jadi tidak jalan.mohon solusinya

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4b

Re: Sheet di protect macro tidak jalan

Mon Apr 24, 2017 10:08 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Agar tetap berjalan, Sheet (Range) yang diedit harus dalam keadaan Unprotect.
Jika Sheet mau tetap diprotect tetapi macro bisa dijalankan maka sebelum Sheet diprotect--> bagian (Range) yang mau diedit harus diUnlocked dulu dengan jalan...Klik kanan Format Cell lalu klik Protection dan cabut centang pada kotak "Locked".
Salam,HK

From: "farud oke farud.oke@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 25 April 2017, 11:30
Subject: [belajar-excel] Sheet di protect macro tidak jalan

  Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula jalan jadi tidak jalan.mohon solusinya #yiv5541600276 #yiv5541600276 -- #yiv5541600276ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5541600276 #yiv5541600276ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5541600276 #yiv5541600276ygrp-mkp #yiv5541600276hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5541600276 #yiv5541600276ygrp-mkp #yiv5541600276ads {margin-bottom:10px;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad {padding:0 0;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad p {margin:0;}#yiv5541600276 #yiv5541600276ygrp-mkp .yiv5541600276ad a {color:#0000ff;text-decoration:none;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc {font-family:Arial;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc #yiv5541600276hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ygrp-lc .yiv5541600276ad {margin-bottom:10px;padding:0 0;}#yiv5541600276 #yiv5541600276actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5541600276 #yiv5541600276activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5541600276 #yiv5541600276activity span {font-weight:700;}#yiv5541600276 #yiv5541600276activity span:first-child {text-transform:uppercase;}#yiv5541600276 #yiv5541600276activity span a {color:#5085b6;text-decoration:none;}#yiv5541600276 #yiv5541600276activity span span {color:#ff7900;}#yiv5541600276 #yiv5541600276activity span .yiv5541600276underline {text-decoration:underline;}#yiv5541600276 .yiv5541600276attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5541600276 .yiv5541600276attach div a {text-decoration:none;}#yiv5541600276 .yiv5541600276attach img {border:none;padding-right:5px;}#yiv5541600276 .yiv5541600276attach label {display:block;margin-bottom:5px;}#yiv5541600276 .yiv5541600276attach label a {text-decoration:none;}#yiv5541600276 blockquote {margin:0 0 0 4px;}#yiv5541600276 .yiv5541600276bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5541600276 .yiv5541600276bold a {text-decoration:none;}#yiv5541600276 dd.yiv5541600276last p a {font-family:Verdana;font-weight:700;}#yiv5541600276 dd.yiv5541600276last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5541600276 dd.yiv5541600276last p span.yiv5541600276yshortcuts {margin-right:0;}#yiv5541600276 div.yiv5541600276attach-table div div a {text-decoration:none;}#yiv5541600276 div.yiv5541600276attach-table {width:400px;}#yiv5541600276 div.yiv5541600276file-title a, #yiv5541600276 div.yiv5541600276file-title a:active, #yiv5541600276 div.yiv5541600276file-title a:hover, #yiv5541600276 div.yiv5541600276file-title a:visited {text-decoration:none;}#yiv5541600276 div.yiv5541600276photo-title a, #yiv5541600276 div.yiv5541600276photo-title a:active, #yiv5541600276 div.yiv5541600276photo-title a:hover, #yiv5541600276 div.yiv5541600276photo-title a:visited {text-decoration:none;}#yiv5541600276 div#yiv5541600276ygrp-mlmsg #yiv5541600276ygrp-msg p a span.yiv5541600276yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5541600276 .yiv5541600276green {color:#628c2a;}#yiv5541600276 .yiv5541600276MsoNormal {margin:0 0 0 0;}#yiv5541600276 o {font-size:0;}#yiv5541600276 #yiv5541600276photos div {float:left;width:72px;}#yiv5541600276 #yiv5541600276photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5541600276 #yiv5541600276photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5541600276 #yiv5541600276reco-category {font-size:77%;}#yiv5541600276 #yiv5541600276reco-desc {font-size:77%;}#yiv5541600276 .yiv5541600276replbq {margin:4px;}#yiv5541600276 #yiv5541600276ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5541600276 #yiv5541600276ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5541600276 #yiv5541600276ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5541600276 #yiv5541600276ygrp-mlmsg select, #yiv5541600276 input, #yiv5541600276 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5541600276 #yiv5541600276ygrp-mlmsg pre, #yiv5541600276 code {font:115% monospace;}#yiv5541600276 #yiv5541600276ygrp-mlmsg * {line-height:1.22em;}#yiv5541600276 #yiv5541600276ygrp-mlmsg #yiv5541600276logo {padding-bottom:10px;}#yiv5541600276 #yiv5541600276ygrp-msg p a {font-family:Verdana;}#yiv5541600276 #yiv5541600276ygrp-msg p#yiv5541600276attach-count span {color:#1E66AE;font-weight:700;}#yiv5541600276 #yiv5541600276ygrp-reco #yiv5541600276reco-head {color:#ff7900;font-weight:700;}#yiv5541600276 #yiv5541600276ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov li a {font-size:130%;text-decoration:none;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5541600276 #yiv5541600276ygrp-sponsor #yiv5541600276ov ul {margin:0;padding:0 0 0 8px;}#yiv5541600276 #yiv5541600276ygrp-text {font-family:Georgia;}#yiv5541600276 #yiv5541600276ygrp-text p {margin:0 0 1em 0;}#yiv5541600276 #yiv5541600276ygrp-text tt {font-size:120%;}#yiv5541600276 #yiv5541600276ygrp-vital ul li:last-child {border-right:none !important;}#yiv5541600276

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4c

Re: Sheet di protect macro tidak jalan

Mon Apr 24, 2017 11:40 pm (PDT) . Posted by:

"Matzen, M. (Matzen)"

Mungkin di dalam process macronya ditambahkan protect dan unprotect sheet

Terima Kasih

Matzen

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 25 April 2017 12:09
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Sheet di protect macro tidak jalan


Agar tetap berjalan, Sheet (Range) yang diedit harus dalam keadaan Unprotect.

Jika Sheet mau tetap diprotect tetapi macro bisa dijalankan maka sebelum Sheet diprotect--> bagian (Range) yang mau diedit harus diUnlocked dulu dengan jalan...
Klik kanan Format Cell lalu klik Protection dan cabut centang pada kotak "Locked".

Salam,
HK
________________________________
From: "farud oke farud.oke@gmail.com<mailto:farud.oke@gmail.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Sent: Tuesday, 25 April 2017, 11:30
Subject: [belajar-excel] Sheet di protect macro tidak jalan


Mohon bantuan para master
Ketika sheet di protect menggunakan review==>>protect sheet macro yg semula jalan jadi tidak jalan.mohon solusinya



__________________________________________________________
This email has been scanned by AkzoNobel for Viruses and Spam.
For more information please contact your local IT Service Desk.
__________________________________________________________

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4d

Re: Sheet di protect macro tidak jalan

Tue Apr 25, 2017 12:02 am (PDT) . Posted by:

"nangagus"

Jika diprotect menggunakan userinterfaceonly = true,

maka macro masih jalan walaupun sheet terproteksi

On 25/04/17 06.02, farud oke farud.oke@gmail.com [belajar-excel] wrote:
>
> Mohon bantuan para master
> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
> semula jalan jadi tidak jalan.mohon solusinya
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4e

Re: Sheet di protect macro tidak jalan

Tue Apr 25, 2017 12:40 am (PDT) . Posted by:

"farud oke"

Ditempatkan dmna? workbook ato d module mas..
Bsa dkasih script lgkapny..

Pada tanggal 25 Apr 2017 2.02 PM, "nangagus nangagus@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

>
>
> Jika diprotect menggunakan userinterfaceonly = true,
>
> maka macro masih jalan walaupun sheet terproteksi
>
>
>
> On 25/04/17 06.02, farud oke farud.oke@gmail.com [belajar-excel] wrote:
>
>
>
> Mohon bantuan para master
> Ketika sheet di protect menggunakan review==>>protect sheet macro yg
> semula jalan jadi tidak jalan.mohon solusinya
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

5

http://info.yahoo.com/legal/us/yahoo/utos/terms/

Mon Apr 24, 2017 9:30 pm (PDT) . Posted by:

Assalamu'alaikum wr wb

Gan
mohon bantuanya dong
bagaimana caranya agar bisa menghide otomatis tabel yang ksong agar bisa lebih rapi
jadi ketika data yang kita buat sedikit, maka otomatis tabel yang ksong akan tersembunyi secara otomatis
ini saya lampirkan file saya

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use