Hai Ayub,
Ikutan boleh yaa..
1. Anda bisa memanfaatkan fungsi NameManager, artinya jika target lebih dari
satu cell, anda dapat membuat NameManager dengan memanfaatkan formula Offset,
maka targetnya akan bergerak dinamis sesuai range yang anda buat di
NameManager.Gunakan Name yang ada di NameManager sebagai target Range
2. Anda bisa gunakan Method FIND pada VBA yang anda masukan ke dalam Event
Workbook_BeforeSave() Gunanya Mehod FIND adalah mencari sesuata dalam hal ini
kata "Error", jika di temukan kata Error, maka workbook ngga bisa di Save, jika
tidak temukan maka workbook bisa di Save.
TerimaKasih
Pada Rabu, 18 Mei 2016 7:03, "Ayub Barin [email protected]
[belajar-excel]" <[email protected]> menulis:
Salam Hormat dan Salut, Mr.KidTerima Kasih sebelumnya pencerahannya,
berbakat juga mr.kid berkata kata...., rncana awal mau menampilkan tabel sheet
murni, tp klu memang harus pakai button tl akan dicoba mr. Terima kasih
sebelumnya...saaaangat bermanfaaat...Salam Hormat san salut #yiv7115562756
#yiv7115562756 -- #yiv7115562756ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7115562756
#yiv7115562756ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7115562756
#yiv7115562756ygrp-mkp #yiv7115562756hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7115562756 #yiv7115562756ygrp-mkp #yiv7115562756ads
{margin-bottom:10px;}#yiv7115562756 #yiv7115562756ygrp-mkp .yiv7115562756ad
{padding:0 0;}#yiv7115562756 #yiv7115562756ygrp-mkp .yiv7115562756ad p
{margin:0;}#yiv7115562756 #yiv7115562756ygrp-mkp .yiv7115562756ad a
{color:#0000ff;text-decoration:none;}#yiv7115562756 #yiv7115562756ygrp-sponsor
#yiv7115562756ygrp-lc {font-family:Arial;}#yiv7115562756
#yiv7115562756ygrp-sponsor #yiv7115562756ygrp-lc #yiv7115562756hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7115562756
#yiv7115562756ygrp-sponsor #yiv7115562756ygrp-lc .yiv7115562756ad
{margin-bottom:10px;padding:0 0;}#yiv7115562756 #yiv7115562756actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7115562756
#yiv7115562756activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7115562756
#yiv7115562756activity span {font-weight:700;}#yiv7115562756
#yiv7115562756activity span:first-child
{text-transform:uppercase;}#yiv7115562756 #yiv7115562756activity span a
{color:#5085b6;text-decoration:none;}#yiv7115562756 #yiv7115562756activity span
span {color:#ff7900;}#yiv7115562756 #yiv7115562756activity span
.yiv7115562756underline {text-decoration:underline;}#yiv7115562756
.yiv7115562756attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7115562756 .yiv7115562756attach div a
{text-decoration:none;}#yiv7115562756 .yiv7115562756attach img
{border:none;padding-right:5px;}#yiv7115562756 .yiv7115562756attach label
{display:block;margin-bottom:5px;}#yiv7115562756 .yiv7115562756attach label a
{text-decoration:none;}#yiv7115562756 blockquote {margin:0 0 0
4px;}#yiv7115562756 .yiv7115562756bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7115562756
.yiv7115562756bold a {text-decoration:none;}#yiv7115562756 dd.yiv7115562756last
p a {font-family:Verdana;font-weight:700;}#yiv7115562756 dd.yiv7115562756last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7115562756
dd.yiv7115562756last p span.yiv7115562756yshortcuts
{margin-right:0;}#yiv7115562756 div.yiv7115562756attach-table div div a
{text-decoration:none;}#yiv7115562756 div.yiv7115562756attach-table
{width:400px;}#yiv7115562756 div.yiv7115562756file-title a, #yiv7115562756
div.yiv7115562756file-title a:active, #yiv7115562756
div.yiv7115562756file-title a:hover, #yiv7115562756 div.yiv7115562756file-title
a:visited {text-decoration:none;}#yiv7115562756 div.yiv7115562756photo-title a,
#yiv7115562756 div.yiv7115562756photo-title a:active, #yiv7115562756
div.yiv7115562756photo-title a:hover, #yiv7115562756
div.yiv7115562756photo-title a:visited {text-decoration:none;}#yiv7115562756
div#yiv7115562756ygrp-mlmsg #yiv7115562756ygrp-msg p a
span.yiv7115562756yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7115562756
.yiv7115562756green {color:#628c2a;}#yiv7115562756 .yiv7115562756MsoNormal
{margin:0 0 0 0;}#yiv7115562756 o {font-size:0;}#yiv7115562756
#yiv7115562756photos div {float:left;width:72px;}#yiv7115562756
#yiv7115562756photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7115562756
#yiv7115562756photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7115562756
#yiv7115562756reco-category {font-size:77%;}#yiv7115562756
#yiv7115562756reco-desc {font-size:77%;}#yiv7115562756 .yiv7115562756replbq
{margin:4px;}#yiv7115562756 #yiv7115562756ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7115562756 #yiv7115562756ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7115562756
#yiv7115562756ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7115562756
#yiv7115562756ygrp-mlmsg select, #yiv7115562756 input, #yiv7115562756 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7115562756
#yiv7115562756ygrp-mlmsg pre, #yiv7115562756 code {font:115%
monospace;}#yiv7115562756 #yiv7115562756ygrp-mlmsg *
{line-height:1.22em;}#yiv7115562756 #yiv7115562756ygrp-mlmsg #yiv7115562756logo
{padding-bottom:10px;}#yiv7115562756 #yiv7115562756ygrp-msg p a
{font-family:Verdana;}#yiv7115562756 #yiv7115562756ygrp-msg
p#yiv7115562756attach-count span {color:#1E66AE;font-weight:700;}#yiv7115562756
#yiv7115562756ygrp-reco #yiv7115562756reco-head
{color:#ff7900;font-weight:700;}#yiv7115562756 #yiv7115562756ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7115562756 #yiv7115562756ygrp-sponsor
#yiv7115562756ov li a {font-size:130%;text-decoration:none;}#yiv7115562756
#yiv7115562756ygrp-sponsor #yiv7115562756ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7115562756
#yiv7115562756ygrp-sponsor #yiv7115562756ov ul {margin:0;padding:0 0 0
8px;}#yiv7115562756 #yiv7115562756ygrp-text
{font-family:Georgia;}#yiv7115562756 #yiv7115562756ygrp-text p {margin:0 0 1em
0;}#yiv7115562756 #yiv7115562756ygrp-text tt {font-size:120%;}#yiv7115562756
#yiv7115562756ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7115562756
