[belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]

Milis Belajar Excel mailing list
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

Setelah input cell otomatis terkunci.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]

Milis Belajar Excel mailing list
ini saya kirim lagi file nya
sekalian pertanyaannya biar lbih jelas



    Pada Selasa, 25 April 2017 11:00, "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]> 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



hide otomatis.xlsx (35K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
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 [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 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' [hidden email] [belajar-excel]" <[hidden email]> 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 | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Thanks responnya



Bukan terhidden mas,

Tapi terlihat,tidak bisa diedit,tidak bisa dihapus dll



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Tuesday, April 25, 2017 11:10 AM
*To:* [hidden email]
*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' [hidden email]
[belajar-excel]" <[hidden email]> 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





image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
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: [hidden email] [mailto:[hidden email]]
Sent: 25 April 2017 13:45
To: [hidden email]
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: [hidden email]<mailto:[hidden email]> [mailto:[hidden email]<mailto:[hidden email]>]
Sent: Tuesday, April 25, 2017 11:10 AM
To: [hidden email]<mailto:[hidden email]>
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' [hidden email]<mailto:[hidden email]> [belajar-excel]" <[hidden email]<mailto:[hidden email]>> 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 | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
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' [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 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: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, April 25, 2017 11:10 AM
To: [hidden email]
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' [hidden email] [belajar-excel]" <[hidden email]> 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 | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
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:* [hidden email] [mailto:[hidden email]]

*Sent:* Tuesday, April 25, 2017 2:39 PM
*To:* [hidden email]
*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' [hidden email] [belajar-excel]" <
[hidden email]>
*To:* [hidden email]
*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:* [hidden email] [mailto:[hidden email]]

*Sent:* Tuesday, April 25, 2017 11:10 AM
*To:* [hidden email]
*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' [hidden email]
[belajar-excel]" <[hidden email]> 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







image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
Hai Ade,
Maaf, saya salah menafsirkan pertanyaan.
Kalau begitu perlu dibuat dua Sheets, yaitu Sheet INPUT (Sheet untuk menginput data) dan Sheet DATA (Sheet untuk menyimpan hasil input).
Sheet DATA harus selalu dalam keadaan terproteksi.
Pada saat input sdh lengkap dan sdh dicek, klik tombol OK untuk menyimpan data pada Sheet DATA, dengan terlebih dahulu mengUnprotect Sheet DATA kemudian memProtectnya kembali.
Setelah itu Sheet INPUT dikosongkan untuk menampung input baru.
(Catatan : Untuk menyimpan (memindahkan) data dari Sheet INPUT ke Sheet DATA bisa dilakukan dengan cara COPY TRANSPOSE).
Catat langkah2nya secara detail kemudian gunakan macro recording untuk merekam langkah2 yang dilakukan.Lakukan edit pada macronya jika diperlukan.
Silakan dicoba dulu.
Salam,HK
 
      From: "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 Sent: Tuesday, 25 April 2017, 15:19
 Subject: RE: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)
   
    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: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, April 25, 2017 2:39 PM
To: [hidden email]
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.ProtectEnd Sub Salam,HKFrom: "'M.Ade Alfarid' [hidden email] [belajar-excel]" <[hidden email]>
To: [hidden email]
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: [hidden email] [mailto:[hidden email]]
Sent: Tuesday, April 25, 2017 11:10 AM
To: [hidden email]
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' [hidden email] [belajar-excel]" <[hidden email]> 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    #yiv3790570796 #yiv3790570796 -- #yiv3790570796ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3790570796 #yiv3790570796ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3790570796 #yiv3790570796ygrp-mkp #yiv3790570796hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3790570796 #yiv3790570796ygrp-mkp #yiv3790570796ads {margin-bottom:10px;}#yiv3790570796 #yiv3790570796ygrp-mkp .yiv3790570796ad {padding:0 0;}#yiv3790570796 #yiv3790570796ygrp-mkp .yiv3790570796ad p {margin:0;}#yiv3790570796 #yiv3790570796ygrp-mkp .yiv3790570796ad a {color:#0000ff;text-decoration:none;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ygrp-lc {font-family:Arial;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ygrp-lc #yiv3790570796hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ygrp-lc .yiv3790570796ad {margin-bottom:10px;padding:0 0;}#yiv3790570796 #yiv3790570796actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3790570796 #yiv3790570796activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3790570796 #yiv3790570796activity span {font-weight:700;}#yiv3790570796 #yiv3790570796activity span:first-child {text-transform:uppercase;}#yiv3790570796 #yiv3790570796activity span a {color:#5085b6;text-decoration:none;}#yiv3790570796 #yiv3790570796activity span span {color:#ff7900;}#yiv3790570796 #yiv3790570796activity span .yiv3790570796underline {text-decoration:underline;}#yiv3790570796 .yiv3790570796attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3790570796 .yiv3790570796attach div a {text-decoration:none;}#yiv3790570796 .yiv3790570796attach img {border:none;padding-right:5px;}#yiv3790570796 .yiv3790570796attach label {display:block;margin-bottom:5px;}#yiv3790570796 .yiv3790570796attach label a {text-decoration:none;}#yiv3790570796 blockquote {margin:0 0 0 4px;}#yiv3790570796 .yiv3790570796bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3790570796 .yiv3790570796bold a {text-decoration:none;}#yiv3790570796 dd.yiv3790570796last p a {font-family:Verdana;font-weight:700;}#yiv3790570796 dd.yiv3790570796last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3790570796 dd.yiv3790570796last p span.yiv3790570796yshortcuts {margin-right:0;}#yiv3790570796 div.yiv3790570796attach-table div div a {text-decoration:none;}#yiv3790570796 div.yiv3790570796attach-table {width:400px;}#yiv3790570796 div.yiv3790570796file-title a, #yiv3790570796 div.yiv3790570796file-title a:active, #yiv3790570796 div.yiv3790570796file-title a:hover, #yiv3790570796 div.yiv3790570796file-title a:visited {text-decoration:none;}#yiv3790570796 div.yiv3790570796photo-title a, #yiv3790570796 div.yiv3790570796photo-title a:active, #yiv3790570796 div.yiv3790570796photo-title a:hover, #yiv3790570796 div.yiv3790570796photo-title a:visited {text-decoration:none;}#yiv3790570796 div#yiv3790570796ygrp-mlmsg #yiv3790570796ygrp-msg p a span.yiv3790570796yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3790570796 .yiv3790570796green {color:#628c2a;}#yiv3790570796 .yiv3790570796MsoNormal {margin:0 0 0 0;}#yiv3790570796 o {font-size:0;}#yiv3790570796 #yiv3790570796photos div {float:left;width:72px;}#yiv3790570796 #yiv3790570796photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3790570796 #yiv3790570796photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3790570796 #yiv3790570796reco-category {font-size:77%;}#yiv3790570796 #yiv3790570796reco-desc {font-size:77%;}#yiv3790570796 .yiv3790570796replbq {margin:4px;}#yiv3790570796 #yiv3790570796ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3790570796 #yiv3790570796ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3790570796 #yiv3790570796ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3790570796 #yiv3790570796ygrp-mlmsg select, #yiv3790570796 input, #yiv3790570796 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3790570796 #yiv3790570796ygrp-mlmsg pre, #yiv3790570796 code {font:115% monospace;}#yiv3790570796 #yiv3790570796ygrp-mlmsg * {line-height:1.22em;}#yiv3790570796 #yiv3790570796ygrp-mlmsg #yiv3790570796logo {padding-bottom:10px;}#yiv3790570796 #yiv3790570796ygrp-msg p a {font-family:Verdana;}#yiv3790570796 #yiv3790570796ygrp-msg p#yiv3790570796attach-count span {color:#1E66AE;font-weight:700;}#yiv3790570796 #yiv3790570796ygrp-reco #yiv3790570796reco-head {color:#ff7900;font-weight:700;}#yiv3790570796 #yiv3790570796ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ov li a {font-size:130%;text-decoration:none;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3790570796 #yiv3790570796ygrp-sponsor #yiv3790570796ov ul {margin:0;padding:0 0 0 8px;}#yiv3790570796 #yiv3790570796ygrp-text {font-family:Georgia;}#yiv3790570796 #yiv3790570796ygrp-text p {margin:0 0 1em 0;}#yiv3790570796 #yiv3790570796ygrp-text tt {font-size:120%;}#yiv3790570796 #yiv3790570796ygrp-vital ul li:last-child {border-right:none !important;}#yiv3790570796

   
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit) [1 Attachment]

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Ikut usul penguncian.

Worksheet diprotect menggunakan userinterfaceonly =true

misalnya diletakkan di workbook open

Private Sub Workbook_Open()
Dim w As Worksheet
Sheet1.Protect "xx", , , , True
End Sub


kemudian di Sheet1 yang sudah diprotect dengan userinterfaceonly,

1. Protect cell di nonaktifkan

(misalnya Range A1 sampai B100) diblok, format cell, pada tab
Protection, buang centang Locked

2. Buat cekrip di sheet dengan tujuan agar cell yang ada isinya Locked =
true

Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Range
For Each x In Range("A1:B100")
If Len(x) > 1 Then x.Locked = True
Next x
End Sub

dapat dicoba pada file lampiran

NB: jika mau ditambah dengan peringatan atau helep dan sejenisnya bisa
ditambahkan beberapa if di cekrip, silahkan dikembangkan.

salam




On 25/04/17 10.56, 'M.Ade Alfarid' [hidden email] [belajar-excel] wrote:

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


protect.xlsm (24K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: Bls: [belajar-excel] Setelah Input,cell otomatis terkunci (tidak bisa dihapus,tidak bisa diedit)

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Terima kasih Dalam Hide otomatis sudah terpecahkannamun mengapa tidak berfungsi jika cell A1 dlink dengan sheet atau cell Lain (ex: A1 = L4)dan juga jika A1 dikasih Spin Buton


mOhon Pencerahanyya
ini saya lampirkan file saya sekaligus pertanyaannya di dalam lampiran





    Pada Selasa, 25 April 2017 11:58, "hendrik karnadi [hidden email] [belajar-excel]" <[hidden email]> menulis:



     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 [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 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' [hidden email] [belajar-excel]" <[hidden email]> 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





     #yiv4136287940 #yiv4136287940 -- #yiv4136287940ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4136287940 #yiv4136287940ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4136287940 #yiv4136287940ygrp-mkp #yiv4136287940hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4136287940 #yiv4136287940ygrp-mkp #yiv4136287940ads {margin-bottom:10px;}#yiv4136287940 #yiv4136287940ygrp-mkp .yiv4136287940ad {padding:0 0;}#yiv4136287940 #yiv4136287940ygrp-mkp .yiv4136287940ad p {margin:0;}#yiv4136287940 #yiv4136287940ygrp-mkp .yiv4136287940ad a {color:#0000ff;text-decoration:none;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ygrp-lc {font-family:Arial;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ygrp-lc #yiv4136287940hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ygrp-lc .yiv4136287940ad {margin-bottom:10px;padding:0 0;}#yiv4136287940 #yiv4136287940actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4136287940 #yiv4136287940activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4136287940 #yiv4136287940activity span {font-weight:700;}#yiv4136287940 #yiv4136287940activity span:first-child {text-transform:uppercase;}#yiv4136287940 #yiv4136287940activity span a {color:#5085b6;text-decoration:none;}#yiv4136287940 #yiv4136287940activity span span {color:#ff7900;}#yiv4136287940 #yiv4136287940activity span .yiv4136287940underline {text-decoration:underline;}#yiv4136287940 .yiv4136287940attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4136287940 .yiv4136287940attach div a {text-decoration:none;}#yiv4136287940 .yiv4136287940attach img {border:none;padding-right:5px;}#yiv4136287940 .yiv4136287940attach label {display:block;margin-bottom:5px;}#yiv4136287940 .yiv4136287940attach label a {text-decoration:none;}#yiv4136287940 blockquote {margin:0 0 0 4px;}#yiv4136287940 .yiv4136287940bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4136287940 .yiv4136287940bold a {text-decoration:none;}#yiv4136287940 dd.yiv4136287940last p a {font-family:Verdana;font-weight:700;}#yiv4136287940 dd.yiv4136287940last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4136287940 dd.yiv4136287940last p span.yiv4136287940yshortcuts {margin-right:0;}#yiv4136287940 div.yiv4136287940attach-table div div a {text-decoration:none;}#yiv4136287940 div.yiv4136287940attach-table {width:400px;}#yiv4136287940 div.yiv4136287940file-title a, #yiv4136287940 div.yiv4136287940file-title a:active, #yiv4136287940 div.yiv4136287940file-title a:hover, #yiv4136287940 div.yiv4136287940file-title a:visited {text-decoration:none;}#yiv4136287940 div.yiv4136287940photo-title a, #yiv4136287940 div.yiv4136287940photo-title a:active, #yiv4136287940 div.yiv4136287940photo-title a:hover, #yiv4136287940 div.yiv4136287940photo-title a:visited {text-decoration:none;}#yiv4136287940 div#yiv4136287940ygrp-mlmsg #yiv4136287940ygrp-msg p a span.yiv4136287940yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4136287940 .yiv4136287940green {color:#628c2a;}#yiv4136287940 .yiv4136287940MsoNormal {margin:0 0 0 0;}#yiv4136287940 o {font-size:0;}#yiv4136287940 #yiv4136287940photos div {float:left;width:72px;}#yiv4136287940 #yiv4136287940photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4136287940 #yiv4136287940photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4136287940 #yiv4136287940reco-category {font-size:77%;}#yiv4136287940 #yiv4136287940reco-desc {font-size:77%;}#yiv4136287940 .yiv4136287940replbq {margin:4px;}#yiv4136287940 #yiv4136287940ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4136287940 #yiv4136287940ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4136287940 #yiv4136287940ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4136287940 #yiv4136287940ygrp-mlmsg select, #yiv4136287940 input, #yiv4136287940 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4136287940 #yiv4136287940ygrp-mlmsg pre, #yiv4136287940 code {font:115% monospace;}#yiv4136287940 #yiv4136287940ygrp-mlmsg * {line-height:1.22em;}#yiv4136287940 #yiv4136287940ygrp-mlmsg #yiv4136287940logo {padding-bottom:10px;}#yiv4136287940 #yiv4136287940ygrp-msg p a {font-family:Verdana;}#yiv4136287940 #yiv4136287940ygrp-msg p#yiv4136287940attach-count span {color:#1E66AE;font-weight:700;}#yiv4136287940 #yiv4136287940ygrp-reco #yiv4136287940reco-head {color:#ff7900;font-weight:700;}#yiv4136287940 #yiv4136287940ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ov li a {font-size:130%;text-decoration:none;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4136287940 #yiv4136287940ygrp-sponsor #yiv4136287940ov ul {margin:0;padding:0 0 0 8px;}#yiv4136287940 #yiv4136287940ygrp-text {font-family:Georgia;}#yiv4136287940 #yiv4136287940ygrp-text p {margin:0 0 1em 0;}#yiv4136287940 #yiv4136287940ygrp-text tt {font-size:120%;}#yiv4136287940 #yiv4136287940ygrp-vital ul li:last-child {border-right:none !important;}#yiv4136287940


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
Mohon bantuannya gan
agar scrip itu bisa jalan pada spin button atau[un link
Loading...