Hai Ayub, Saya coba buatkan seperti permasalah yang anda hadapi, untuk kolom Keteranga saya protect agar user tidak merubah formulanya, passwordnya:123Jika Salah satu kolom tidak terisis, maka sheet tersebut tidak bisa meng-save.Saya menggunakan apa yang pernah saya sampaikan kepada anda.Semoga bisa menambah wawasan anda mengenai VBA dan semangat anda untuk terus belajar EXCEL.
TerimaKasih.
Pada Rabu, 18 Mei 2016 21:36, "Ayub Barin [email protected]
[belajar-excel]" <[email protected]> menulis:
Salam Hormat dan Salut..., Maaf ketinggalan dikit, akal-akalan saya supaya
cell g1 tidak membaca err kolom yg seluruhnya belum terisi maka saya
persyaratkan kolom terakhir yg diisi sbgai validasiCell g2 =
if(e2<>0;if(or(b2="";d2="");"Err";"");"")Wlupun tidak efektif sbb apabila
pengguna mengetahui validasi ada di cell e2 brrti lembar kerja bisa saja
disimpan dgn tidak mengisi cell yg berstatus sbg validasi cell lainDemikian
tambahan,termksh
Salam hormat dan salut #yiv4198510743 #yiv4198510743 -- #yiv4198510743ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv4198510743 #yiv4198510743ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4198510743 #yiv4198510743ygrp-mkp #yiv4198510743hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4198510743 #yiv4198510743ygrp-mkp #yiv4198510743ads
{margin-bottom:10px;}#yiv4198510743 #yiv4198510743ygrp-mkp .yiv4198510743ad
{padding:0 0;}#yiv4198510743 #yiv4198510743ygrp-mkp .yiv4198510743ad p
{margin:0;}#yiv4198510743 #yiv4198510743ygrp-mkp .yiv4198510743ad a
{color:#0000ff;text-decoration:none;}#yiv4198510743 #yiv4198510743ygrp-sponsor
#yiv4198510743ygrp-lc {font-family:Arial;}#yiv4198510743
#yiv4198510743ygrp-sponsor #yiv4198510743ygrp-lc #yiv4198510743hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4198510743
#yiv4198510743ygrp-sponsor #yiv4198510743ygrp-lc .yiv4198510743ad
{margin-bottom:10px;padding:0 0;}#yiv4198510743 #yiv4198510743actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4198510743
#yiv4198510743activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4198510743
#yiv4198510743activity span {font-weight:700;}#yiv4198510743
#yiv4198510743activity span:first-child
{text-transform:uppercase;}#yiv4198510743 #yiv4198510743activity span a
{color:#5085b6;text-decoration:none;}#yiv4198510743 #yiv4198510743activity span
span {color:#ff7900;}#yiv4198510743 #yiv4198510743activity span
.yiv4198510743underline {text-decoration:underline;}#yiv4198510743
.yiv4198510743attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4198510743 .yiv4198510743attach div a
{text-decoration:none;}#yiv4198510743 .yiv4198510743attach img
{border:none;padding-right:5px;}#yiv4198510743 .yiv4198510743attach label
{display:block;margin-bottom:5px;}#yiv4198510743 .yiv4198510743attach label a
{text-decoration:none;}#yiv4198510743 blockquote {margin:0 0 0
4px;}#yiv4198510743 .yiv4198510743bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4198510743
.yiv4198510743bold a {text-decoration:none;}#yiv4198510743 dd.yiv4198510743last
p a {font-family:Verdana;font-weight:700;}#yiv4198510743 dd.yiv4198510743last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4198510743
dd.yiv4198510743last p span.yiv4198510743yshortcuts
{margin-right:0;}#yiv4198510743 div.yiv4198510743attach-table div div a
{text-decoration:none;}#yiv4198510743 div.yiv4198510743attach-table
{width:400px;}#yiv4198510743 div.yiv4198510743file-title a, #yiv4198510743
div.yiv4198510743file-title a:active, #yiv4198510743
div.yiv4198510743file-title a:hover, #yiv4198510743 div.yiv4198510743file-title
a:visited {text-decoration:none;}#yiv4198510743 div.yiv4198510743photo-title a,
#yiv4198510743 div.yiv4198510743photo-title a:active, #yiv4198510743
div.yiv4198510743photo-title a:hover, #yiv4198510743
div.yiv4198510743photo-title a:visited {text-decoration:none;}#yiv4198510743
div#yiv4198510743ygrp-mlmsg #yiv4198510743ygrp-msg p a
span.yiv4198510743yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4198510743
.yiv4198510743green {color:#628c2a;}#yiv4198510743 .yiv4198510743MsoNormal
{margin:0 0 0 0;}#yiv4198510743 o {font-size:0;}#yiv4198510743
#yiv4198510743photos div {float:left;width:72px;}#yiv4198510743
#yiv4198510743photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4198510743
#yiv4198510743photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4198510743
#yiv4198510743reco-category {font-size:77%;}#yiv4198510743
#yiv4198510743reco-desc {font-size:77%;}#yiv4198510743 .yiv4198510743replbq
{margin:4px;}#yiv4198510743 #yiv4198510743ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4198510743 #yiv4198510743ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4198510743
#yiv4198510743ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4198510743
#yiv4198510743ygrp-mlmsg select, #yiv4198510743 input, #yiv4198510743 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4198510743
#yiv4198510743ygrp-mlmsg pre, #yiv4198510743 code {font:115%
monospace;}#yiv4198510743 #yiv4198510743ygrp-mlmsg *
{line-height:1.22em;}#yiv4198510743 #yiv4198510743ygrp-mlmsg #yiv4198510743logo
{padding-bottom:10px;}#yiv4198510743 #yiv4198510743ygrp-msg p a
{font-family:Verdana;}#yiv4198510743 #yiv4198510743ygrp-msg
p#yiv4198510743attach-count span {color:#1E66AE;font-weight:700;}#yiv4198510743
#yiv4198510743ygrp-reco #yiv4198510743reco-head
{color:#ff7900;font-weight:700;}#yiv4198510743 #yiv4198510743ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4198510743 #yiv4198510743ygrp-sponsor
#yiv4198510743ov li a {font-size:130%;text-decoration:none;}#yiv4198510743
#yiv4198510743ygrp-sponsor #yiv4198510743ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4198510743
#yiv4198510743ygrp-sponsor #yiv4198510743ov ul {margin:0;padding:0 0 0
8px;}#yiv4198510743 #yiv4198510743ygrp-text
{font-family:Georgia;}#yiv4198510743 #yiv4198510743ygrp-text p {margin:0 0 1em
0;}#yiv4198510743 #yiv4198510743ygrp-text tt {font-size:120%;}#yiv4198510743
#yiv4198510743ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4198510743
close.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
