tengkyu mr. kid
ada lagi nih...saya mau protect sheet...tapi freeze panes aktif...gimana ya..
tks
Pada Selasa, 24 November 2015 6:36, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Marone,
Manualnya begini :
1. ribbon Review -> group Changes -> Protect Sheet -> muncul dialog window
protect sheet
2. isi password (bila perlu) -> centang yang diperbolehkan -> tekan OK
untuk bisa border, berarti format cells yang di centang. Tapi, segala
macam format cells bisa dilakukan.
Jika ingin tahu kode VBA nya, lakukan cara manual tersebut saat proses record
macro dijalankan, alias lakukan macro recording
Regards,
Kid
On Mon, Nov 23, 2015 at 6:12 PM, marone oke [email protected]
[belajar-excel] <[email protected]> wrote:
dear master,,
tolong code macro, protect sheet tapi borders tetap aktif.....
tks bantuannya
#yiv5606556196 #yiv5606556196 -- #yiv5606556196ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5606556196
#yiv5606556196ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5606556196
#yiv5606556196ygrp-mkp #yiv5606556196hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5606556196 #yiv5606556196ygrp-mkp #yiv5606556196ads
{margin-bottom:10px;}#yiv5606556196 #yiv5606556196ygrp-mkp .yiv5606556196ad
{padding:0 0;}#yiv5606556196 #yiv5606556196ygrp-mkp .yiv5606556196ad p
{margin:0;}#yiv5606556196 #yiv5606556196ygrp-mkp .yiv5606556196ad a
{color:#0000ff;text-decoration:none;}#yiv5606556196 #yiv5606556196ygrp-sponsor
#yiv5606556196ygrp-lc {font-family:Arial;}#yiv5606556196
#yiv5606556196ygrp-sponsor #yiv5606556196ygrp-lc #yiv5606556196hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5606556196
#yiv5606556196ygrp-sponsor #yiv5606556196ygrp-lc .yiv5606556196ad
{margin-bottom:10px;padding:0 0;}#yiv5606556196 #yiv5606556196actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5606556196
#yiv5606556196activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5606556196
#yiv5606556196activity span {font-weight:700;}#yiv5606556196
#yiv5606556196activity span:first-child
{text-transform:uppercase;}#yiv5606556196 #yiv5606556196activity span a
{color:#5085b6;text-decoration:none;}#yiv5606556196 #yiv5606556196activity span
span {color:#ff7900;}#yiv5606556196 #yiv5606556196activity span
.yiv5606556196underline {text-decoration:underline;}#yiv5606556196
.yiv5606556196attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5606556196 .yiv5606556196attach div a
{text-decoration:none;}#yiv5606556196 .yiv5606556196attach img
{border:none;padding-right:5px;}#yiv5606556196 .yiv5606556196attach label
{display:block;margin-bottom:5px;}#yiv5606556196 .yiv5606556196attach label a
{text-decoration:none;}#yiv5606556196 blockquote {margin:0 0 0
4px;}#yiv5606556196 .yiv5606556196bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5606556196
.yiv5606556196bold a {text-decoration:none;}#yiv5606556196 dd.yiv5606556196last
p a {font-family:Verdana;font-weight:700;}#yiv5606556196 dd.yiv5606556196last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5606556196
dd.yiv5606556196last p span.yiv5606556196yshortcuts
{margin-right:0;}#yiv5606556196 div.yiv5606556196attach-table div div a
{text-decoration:none;}#yiv5606556196 div.yiv5606556196attach-table
{width:400px;}#yiv5606556196 div.yiv5606556196file-title a, #yiv5606556196
div.yiv5606556196file-title a:active, #yiv5606556196
div.yiv5606556196file-title a:hover, #yiv5606556196 div.yiv5606556196file-title
a:visited {text-decoration:none;}#yiv5606556196 div.yiv5606556196photo-title a,
#yiv5606556196 div.yiv5606556196photo-title a:active, #yiv5606556196
div.yiv5606556196photo-title a:hover, #yiv5606556196
div.yiv5606556196photo-title a:visited {text-decoration:none;}#yiv5606556196
div#yiv5606556196ygrp-mlmsg #yiv5606556196ygrp-msg p a
span.yiv5606556196yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5606556196
.yiv5606556196green {color:#628c2a;}#yiv5606556196 .yiv5606556196MsoNormal
{margin:0 0 0 0;}#yiv5606556196 o {font-size:0;}#yiv5606556196
#yiv5606556196photos div {float:left;width:72px;}#yiv5606556196
#yiv5606556196photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5606556196
#yiv5606556196photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5606556196
#yiv5606556196reco-category {font-size:77%;}#yiv5606556196
#yiv5606556196reco-desc {font-size:77%;}#yiv5606556196 .yiv5606556196replbq
{margin:4px;}#yiv5606556196 #yiv5606556196ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5606556196 #yiv5606556196ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5606556196
#yiv5606556196ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5606556196
#yiv5606556196ygrp-mlmsg select, #yiv5606556196 input, #yiv5606556196 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5606556196
#yiv5606556196ygrp-mlmsg pre, #yiv5606556196 code {font:115%
monospace;}#yiv5606556196 #yiv5606556196ygrp-mlmsg *
{line-height:1.22em;}#yiv5606556196 #yiv5606556196ygrp-mlmsg #yiv5606556196logo
{padding-bottom:10px;}#yiv5606556196 #yiv5606556196ygrp-msg p a
{font-family:Verdana;}#yiv5606556196 #yiv5606556196ygrp-msg
p#yiv5606556196attach-count span {color:#1E66AE;font-weight:700;}#yiv5606556196
#yiv5606556196ygrp-reco #yiv5606556196reco-head
{color:#ff7900;font-weight:700;}#yiv5606556196 #yiv5606556196ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5606556196 #yiv5606556196ygrp-sponsor
#yiv5606556196ov li a {font-size:130%;text-decoration:none;}#yiv5606556196
#yiv5606556196ygrp-sponsor #yiv5606556196ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5606556196
#yiv5606556196ygrp-sponsor #yiv5606556196ov ul {margin:0;padding:0 0 0
8px;}#yiv5606556196 #yiv5606556196ygrp-text
{font-family:Georgia;}#yiv5606556196 #yiv5606556196ygrp-text p {margin:0 0 1em
0;}#yiv5606556196 #yiv5606556196ygrp-text tt {font-size:120%;}#yiv5606556196
#yiv5606556196ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5606556196