assalamu'alaikum wr.wb
yth mr.kid
file terlalu besar om kid 1,1 mb sudah di kompres hasilnya malah 919 kb kira
kira om kid punya saran gak untuk masalah kompres ini agar om kid juga tau.
formatnya bikin bingung om. jadi kita gak bisa ctrl+a , hanya bisa Ctrl+down
saja tidak bisa kekanan , proteck cellnya jadi gini kita gak bisa mengklik cell
yang di proteck.
kalau setau saya pakai proteck sheet yang ada di ribbom review itu ( kita blok
dahulu data yang ingin tidak di locked (dengan klik kanan terus tab protection
uncek lockednya) nah setelah itu blok keseluruhan data review proteck sheet ).
itu kita memang tidak bisa mengedit tapi seengaknya muncul peringatan kalau
cell tersebut di proteck.begitu juga di validation om kid akan menampilkan
caution atau attention.
tapi difile tersebut tidak muncul apa2 seolah2 cell sudah beku tidak bisa di
utak atik.saya tidak ingin memcahkan kodenya hanya saja saya ingin mengetahui
caranya om. heheeudah searching di mbah goggle yaa caranya yang kaya diatas itu
melalui tab review.
maaf om kid kalau bikin bingung.. :)
wassalamu'alaikum wr.wbterima kasih fahmi
Pada Rabu, 31 Agustus 2016 22:58, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
Gak mudeng maksudnya.
Coba dilampirkan kesini contohnya.
Protect cells bisa dengan data validation, tetapi syarat dan ketentuan yang
berlaku adalah milik data validation.
Wassalamu'alaikum wr wb
Kid
2016-08-31 22:24 GMT+07:00 Fahmi Syaifullah fahmisyaifulla...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Assalamualaikum.Selamat malam master excel sekalian.
tadi saya sempet lihat file excel yg isinya tentang absensi lembur. ada yg
ingin saya tnyakan sama master excel skalian. Disitu ada cell yg diproteck.
Tapi tidak mnggunakan ribbon rivew protek sheet (soalnya kalau pake ribbon tsb
akan muncul sebuah peringatan) tapi difile itu tidak muncul peringatan tsb
walau mau di klik beberapa kali.Filenya berinisial xlsm. Saya buka vbenya gk
ada module atau script lain.
kiranya master excel boleh jelasin kok bisa sperti itu yaa?..
Terima kasih.Wassalamu'alaikum
Dikirim dari Yahoo Mail di Android
#yiv8366607122 #yiv8366607122 -- #yiv8366607122ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8366607122
#yiv8366607122ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8366607122
#yiv8366607122ygrp-mkp #yiv8366607122hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8366607122 #yiv8366607122ygrp-mkp #yiv8366607122ads
{margin-bottom:10px;}#yiv8366607122 #yiv8366607122ygrp-mkp .yiv8366607122ad
{padding:0 0;}#yiv8366607122 #yiv8366607122ygrp-mkp .yiv8366607122ad p
{margin:0;}#yiv8366607122 #yiv8366607122ygrp-mkp .yiv8366607122ad a
{color:#0000ff;text-decoration:none;}#yiv8366607122 #yiv8366607122ygrp-sponsor
#yiv8366607122ygrp-lc {font-family:Arial;}#yiv8366607122
#yiv8366607122ygrp-sponsor #yiv8366607122ygrp-lc #yiv8366607122hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8366607122
#yiv8366607122ygrp-sponsor #yiv8366607122ygrp-lc .yiv8366607122ad
{margin-bottom:10px;padding:0 0;}#yiv8366607122 #yiv8366607122actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8366607122
#yiv8366607122activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8366607122
#yiv8366607122activity span {font-weight:700;}#yiv8366607122
#yiv8366607122activity span:first-child
{text-transform:uppercase;}#yiv8366607122 #yiv8366607122activity span a
{color:#5085b6;text-decoration:none;}#yiv8366607122 #yiv8366607122activity span
span {color:#ff7900;}#yiv8366607122 #yiv8366607122activity span
.yiv8366607122underline {text-decoration:underline;}#yiv8366607122
.yiv8366607122attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8366607122 .yiv8366607122attach div a
{text-decoration:none;}#yiv8366607122 .yiv8366607122attach img
{border:none;padding-right:5px;}#yiv8366607122 .yiv8366607122attach label
{display:block;margin-bottom:5px;}#yiv8366607122 .yiv8366607122attach label a
{text-decoration:none;}#yiv8366607122 blockquote {margin:0 0 0
4px;}#yiv8366607122 .yiv8366607122bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8366607122
.yiv8366607122bold a {text-decoration:none;}#yiv8366607122 dd.yiv8366607122last
p a {font-family:Verdana;font-weight:700;}#yiv8366607122 dd.yiv8366607122last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8366607122
dd.yiv8366607122last p span.yiv8366607122yshortcuts
{margin-right:0;}#yiv8366607122 div.yiv8366607122attach-table div div a
{text-decoration:none;}#yiv8366607122 div.yiv8366607122attach-table
{width:400px;}#yiv8366607122 div.yiv8366607122file-title a, #yiv8366607122
div.yiv8366607122file-title a:active, #yiv8366607122
div.yiv8366607122file-title a:hover, #yiv8366607122 div.yiv8366607122file-title
a:visited {text-decoration:none;}#yiv8366607122 div.yiv8366607122photo-title a,
#yiv8366607122 div.yiv8366607122photo-title a:active, #yiv8366607122
div.yiv8366607122photo-title a:hover, #yiv8366607122
div.yiv8366607122photo-title a:visited {text-decoration:none;}#yiv8366607122
div#yiv8366607122ygrp-mlmsg #yiv8366607122ygrp-msg p a
span.yiv8366607122yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8366607122
.yiv8366607122green {color:#628c2a;}#yiv8366607122 .yiv8366607122MsoNormal
{margin:0 0 0 0;}#yiv8366607122 o {font-size:0;}#yiv8366607122
#yiv8366607122photos div {float:left;width:72px;}#yiv8366607122
#yiv8366607122photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8366607122
#yiv8366607122photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8366607122
#yiv8366607122reco-category {font-size:77%;}#yiv8366607122
#yiv8366607122reco-desc {font-size:77%;}#yiv8366607122 .yiv8366607122replbq
{margin:4px;}#yiv8366607122 #yiv8366607122ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8366607122 #yiv8366607122ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8366607122
#yiv8366607122ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8366607122
#yiv8366607122ygrp-mlmsg select, #yiv8366607122 input, #yiv8366607122 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8366607122
#yiv8366607122ygrp-mlmsg pre, #yiv8366607122 code {font:115%
monospace;}#yiv8366607122 #yiv8366607122ygrp-mlmsg *
{line-height:1.22em;}#yiv8366607122 #yiv8366607122ygrp-mlmsg #yiv8366607122logo
{padding-bottom:10px;}#yiv8366607122 #yiv8366607122ygrp-msg p a
{font-family:Verdana;}#yiv8366607122 #yiv8366607122ygrp-msg
p#yiv8366607122attach-count span {color:#1E66AE;font-weight:700;}#yiv8366607122
#yiv8366607122ygrp-reco #yiv8366607122reco-head
{color:#ff7900;font-weight:700;}#yiv8366607122 #yiv8366607122ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8366607122 #yiv8366607122ygrp-sponsor
#yiv8366607122ov li a {font-size:130%;text-decoration:none;}#yiv8366607122
#yiv8366607122ygrp-sponsor #yiv8366607122ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8366607122
#yiv8366607122ygrp-sponsor #yiv8366607122ov ul {margin:0;padding:0 0 0
8px;}#yiv8366607122 #yiv8366607122ygrp-text
{font-family:Georgia;}#yiv8366607122 #yiv8366607122ygrp-text p {margin:0 0 1em
0;}#yiv8366607122 #yiv8366607122ygrp-text tt {font-size:120%;}#yiv8366607122
#yiv8366607122ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8366607122
