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

Tue, 25 Apr 2017 02:24:13 -0700 

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

Kirim email ke