Terima kasih mas Nang Agus.
Ada sedikit perbedaan dengan yang dibuat Mbak Siti, dimana range yang
diunprotect (bisa diedit) hanya 1, tidak bisa kedua2nya.
Sedangkan apa yang dibuat pak Agus..sekali terbuka akan terbuka terus.
Salam,HK
----- Forwarded Message -----
From: "Nang Agus [email protected] [belajar-excel]"
<[email protected]>
To: BExcel <[email protected]>
Sent: Thursday, 3 September 2015, 12:59
Subject: Re: [belajar-excel] Membuat Kunci Masing-masing Kolom dalam satu sheet
Dear Rahasus,
Usualan pak Hendrik menggunakan VBA,
Dapat juga dilakukan tanpa VBA, jadi user tidak usah mengaktifkan macro caranya:
Pilih Tab Review, klik Allow User to Edit Ranges.
kemudian klik new
Isikan dengan lengkap,
Setelah itu, Protect sheet,
wasalam
2015-09-02 12:00 GMT+07:00 Rahasus Pae [email protected] [belajar-excel]
<[email protected]>:
Hello be-exceler,
Ada caranya memberikan password pada masing-masing kolom tapi dalam 1
sheet.Boss punya data berikut, tapi dia minta supaya kolom C punya password
sendiri, kolom D juga punya password sendiri, karena dia memberikan otorisasi
input data kepada orang yang berbeda untuk kolom C dan D
Mohon pencerahannya, bagaimana cara melakukannya?
Salam,Rahas
#yiv0791745365 #yiv0791745365 -- #yiv0791745365ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0791745365
#yiv0791745365ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0791745365
#yiv0791745365ygrp-mkp #yiv0791745365hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0791745365 #yiv0791745365ygrp-mkp #yiv0791745365ads
{margin-bottom:10px;}#yiv0791745365 #yiv0791745365ygrp-mkp .yiv0791745365ad
{padding:0 0;}#yiv0791745365 #yiv0791745365ygrp-mkp .yiv0791745365ad p
{margin:0;}#yiv0791745365 #yiv0791745365ygrp-mkp .yiv0791745365ad a
{color:#0000ff;text-decoration:none;}#yiv0791745365 #yiv0791745365ygrp-sponsor
#yiv0791745365ygrp-lc {font-family:Arial;}#yiv0791745365
#yiv0791745365ygrp-sponsor #yiv0791745365ygrp-lc #yiv0791745365hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0791745365
#yiv0791745365ygrp-sponsor #yiv0791745365ygrp-lc .yiv0791745365ad
{margin-bottom:10px;padding:0 0;}#yiv0791745365 #yiv0791745365actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0791745365
#yiv0791745365activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0791745365
#yiv0791745365activity span {font-weight:700;}#yiv0791745365
#yiv0791745365activity span:first-child
{text-transform:uppercase;}#yiv0791745365 #yiv0791745365activity span a
{color:#5085b6;text-decoration:none;}#yiv0791745365 #yiv0791745365activity span
span {color:#ff7900;}#yiv0791745365 #yiv0791745365activity span
.yiv0791745365underline {text-decoration:underline;}#yiv0791745365
.yiv0791745365attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0791745365 .yiv0791745365attach div a
{text-decoration:none;}#yiv0791745365 .yiv0791745365attach img
{border:none;padding-right:5px;}#yiv0791745365 .yiv0791745365attach label
{display:block;margin-bottom:5px;}#yiv0791745365 .yiv0791745365attach label a
{text-decoration:none;}#yiv0791745365 blockquote {margin:0 0 0
4px;}#yiv0791745365 .yiv0791745365bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0791745365
.yiv0791745365bold a {text-decoration:none;}#yiv0791745365 dd.yiv0791745365last
p a {font-family:Verdana;font-weight:700;}#yiv0791745365 dd.yiv0791745365last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0791745365
dd.yiv0791745365last p span.yiv0791745365yshortcuts
{margin-right:0;}#yiv0791745365 div.yiv0791745365attach-table div div a
{text-decoration:none;}#yiv0791745365 div.yiv0791745365attach-table
{width:400px;}#yiv0791745365 div.yiv0791745365file-title a, #yiv0791745365
div.yiv0791745365file-title a:active, #yiv0791745365
div.yiv0791745365file-title a:hover, #yiv0791745365 div.yiv0791745365file-title
a:visited {text-decoration:none;}#yiv0791745365 div.yiv0791745365photo-title a,
#yiv0791745365 div.yiv0791745365photo-title a:active, #yiv0791745365
div.yiv0791745365photo-title a:hover, #yiv0791745365
div.yiv0791745365photo-title a:visited {text-decoration:none;}#yiv0791745365
div#yiv0791745365ygrp-mlmsg #yiv0791745365ygrp-msg p a
span.yiv0791745365yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0791745365
.yiv0791745365green {color:#628c2a;}#yiv0791745365 .yiv0791745365MsoNormal
{margin:0 0 0 0;}#yiv0791745365 o {font-size:0;}#yiv0791745365
#yiv0791745365photos div {float:left;width:72px;}#yiv0791745365
#yiv0791745365photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0791745365
#yiv0791745365photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0791745365
#yiv0791745365reco-category {font-size:77%;}#yiv0791745365
#yiv0791745365reco-desc {font-size:77%;}#yiv0791745365 .yiv0791745365replbq
{margin:4px;}#yiv0791745365 #yiv0791745365ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0791745365 #yiv0791745365ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0791745365
#yiv0791745365ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0791745365
#yiv0791745365ygrp-mlmsg select, #yiv0791745365 input, #yiv0791745365 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0791745365
#yiv0791745365ygrp-mlmsg pre, #yiv0791745365 code {font:115%
monospace;}#yiv0791745365 #yiv0791745365ygrp-mlmsg *
{line-height:1.22em;}#yiv0791745365 #yiv0791745365ygrp-mlmsg #yiv0791745365logo
{padding-bottom:10px;}#yiv0791745365 #yiv0791745365ygrp-msg p a
{font-family:Verdana;}#yiv0791745365 #yiv0791745365ygrp-msg
p#yiv0791745365attach-count span {color:#1E66AE;font-weight:700;}#yiv0791745365
#yiv0791745365ygrp-reco #yiv0791745365reco-head
{color:#ff7900;font-weight:700;}#yiv0791745365 #yiv0791745365ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0791745365 #yiv0791745365ygrp-sponsor
#yiv0791745365ov li a {font-size:130%;text-decoration:none;}#yiv0791745365
#yiv0791745365ygrp-sponsor #yiv0791745365ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0791745365
#yiv0791745365ygrp-sponsor #yiv0791745365ov ul {margin:0;padding:0 0 0
8px;}#yiv0791745365 #yiv0791745365ygrp-text
{font-family:Georgia;}#yiv0791745365 #yiv0791745365ygrp-text p {margin:0 0 1em
0;}#yiv0791745365 #yiv0791745365ygrp-text tt {font-size:120%;}#yiv0791745365
#yiv0791745365ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0791745365
