1 Message

Digest #4165

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

Message

1a

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

Tue Apr 25, 2017 2:23 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

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' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
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: 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.ProtectEnd Sub Salam,HKFrom: "'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   #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 to sender . Reply to group . Reply via Web Post . All Messages (8) . 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