Hai Tiny,Untuk mempassword VB...Tekan Alt F11 untuk masuk ke VBE SheetKlik
Tools, VBAProject Properties, Protection....Centang Lock project for viewing
dan masukkan serta confirm PWD (jangan lupa PWD nya).
Salam,,HK
From: "hartini dewi [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, 27 November 2014, 12:47
Subject: [belajar-excel] Password protect sheet
| Dear all,
Saya melakukan hidden sheet menggunakan vb dengan mengganti visible menjadi
veryhidden, bagaimn agar vb tsb bisa di password sehingga sheet yg saya hidden
tdk bisa ditampilkan kecuali saya yg membukanya.
Mohon pencerahannya
Terima kasih
Salam
Tiny |
<!--#yiv1728817097 #yiv1728817097ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1728817097
#yiv1728817097ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1728817097
#yiv1728817097ygrp-mkp #yiv1728817097hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1728817097 #yiv1728817097ygrp-mkp #yiv1728817097ads
{margin-bottom:10px;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad
{padding:0 0;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad p
{margin:0;}#yiv1728817097 #yiv1728817097ygrp-mkp .yiv1728817097ad a
{color:#0000ff;text-decoration:none;}#yiv1728817097 #yiv1728817097ygrp-sponsor
#yiv1728817097ygrp-lc {font-family:Arial;}#yiv1728817097
#yiv1728817097ygrp-sponsor #yiv1728817097ygrp-lc #yiv1728817097hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1728817097
#yiv1728817097ygrp-sponsor #yiv1728817097ygrp-lc .yiv1728817097ad
{margin-bottom:10px;padding:0 0;}#yiv1728817097 #yiv1728817097actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1728817097
#yiv1728817097activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1728817097
#yiv1728817097activity span {font-weight:700;}#yiv1728817097
#yiv1728817097activity span:first-child
{text-transform:uppercase;}#yiv1728817097 #yiv1728817097activity span a
{color:#5085b6;text-decoration:none;}#yiv1728817097 #yiv1728817097activity span
span {color:#ff7900;}#yiv1728817097 #yiv1728817097activity span
.yiv1728817097underline {text-decoration:underline;}#yiv1728817097
.yiv1728817097attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1728817097 .yiv1728817097attach div a
{text-decoration:none;}#yiv1728817097 .yiv1728817097attach img
{border:none;padding-right:5px;}#yiv1728817097 .yiv1728817097attach label
{display:block;margin-bottom:5px;}#yiv1728817097 .yiv1728817097attach label a
{text-decoration:none;}#yiv1728817097 blockquote {margin:0 0 0
4px;}#yiv1728817097 .yiv1728817097bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1728817097
.yiv1728817097bold a {text-decoration:none;}#yiv1728817097 dd.yiv1728817097last
p a {font-family:Verdana;font-weight:700;}#yiv1728817097 dd.yiv1728817097last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1728817097
dd.yiv1728817097last p span.yiv1728817097yshortcuts
{margin-right:0;}#yiv1728817097 div.yiv1728817097attach-table div div a
{text-decoration:none;}#yiv1728817097 div.yiv1728817097attach-table
{width:400px;}#yiv1728817097 div.yiv1728817097file-title a, #yiv1728817097
div.yiv1728817097file-title a:active, #yiv1728817097
div.yiv1728817097file-title a:hover, #yiv1728817097 div.yiv1728817097file-title
a:visited {text-decoration:none;}#yiv1728817097 div.yiv1728817097photo-title a,
#yiv1728817097 div.yiv1728817097photo-title a:active, #yiv1728817097
div.yiv1728817097photo-title a:hover, #yiv1728817097
div.yiv1728817097photo-title a:visited {text-decoration:none;}#yiv1728817097
div#yiv1728817097ygrp-mlmsg #yiv1728817097ygrp-msg p a
span.yiv1728817097yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1728817097
.yiv1728817097green {color:#628c2a;}#yiv1728817097 .yiv1728817097MsoNormal
{margin:0 0 0 0;}#yiv1728817097 o {font-size:0;}#yiv1728817097
#yiv1728817097photos div {float:left;width:72px;}#yiv1728817097
#yiv1728817097photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1728817097
#yiv1728817097photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1728817097
#yiv1728817097reco-category {font-size:77%;}#yiv1728817097
#yiv1728817097reco-desc {font-size:77%;}#yiv1728817097 .yiv1728817097replbq
{margin:4px;}#yiv1728817097 #yiv1728817097ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1728817097 #yiv1728817097ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1728817097
#yiv1728817097ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1728817097
#yiv1728817097ygrp-mlmsg select, #yiv1728817097 input, #yiv1728817097 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1728817097
#yiv1728817097ygrp-mlmsg pre, #yiv1728817097 code {font:115%
monospace;}#yiv1728817097 #yiv1728817097ygrp-mlmsg *
{line-height:1.22em;}#yiv1728817097 #yiv1728817097ygrp-mlmsg #yiv1728817097logo
{padding-bottom:10px;}#yiv1728817097 #yiv1728817097ygrp-msg p a
{font-family:Verdana;}#yiv1728817097 #yiv1728817097ygrp-msg
p#yiv1728817097attach-count span {color:#1E66AE;font-weight:700;}#yiv1728817097
#yiv1728817097ygrp-reco #yiv1728817097reco-head
{color:#ff7900;font-weight:700;}#yiv1728817097 #yiv1728817097ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1728817097 #yiv1728817097ygrp-sponsor
#yiv1728817097ov li a {font-size:130%;text-decoration:none;}#yiv1728817097
#yiv1728817097ygrp-sponsor #yiv1728817097ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1728817097
#yiv1728817097ygrp-sponsor #yiv1728817097ov ul {margin:0;padding:0 0 0
8px;}#yiv1728817097 #yiv1728817097ygrp-text
{font-family:Georgia;}#yiv1728817097 #yiv1728817097ygrp-text p {margin:0 0 1em
0;}#yiv1728817097 #yiv1728817097ygrp-text tt {font-size:120%;}#yiv1728817097
#yiv1728817097ygrp-vital ul li:last-child {border-right:none !important;}-->
