Terimakasih Maaf yang saya maksud untuk hasilnya tidak muncul formula tapi hasil dari vlookup nya saja seperti yang terlampir sebelumnya dan itu cuma 1 contoh dan jika banyak akan tetap hasil saja Terimakasih Pada Selasa, 30 Juli 2019 12.44.47 WIB, Zainul Ulum zainul_u...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Wa’alaikum salaam, File terlampir menggunakan protected sheet tanpa menggunakan macro. Apakah sudah sesuai yang diinginkan? Wassalam -zainul Sent from Mail for Windows 10 From: HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] Sent: Tuesday, July 30, 2019 7:47 AM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] menampilkan hasil tanpa formula di excel dengan script macro Salam Para Master mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir Terimakasih Assalamualaikum Hairul Alam #yiv0658632402 #yiv0658632402 -- #yiv0658632402ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0658632402 #yiv0658632402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402ads {margin-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad {padding:0 0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad p {margin:0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad a {color:#0000ff;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc {font-family:Arial;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc #yiv0658632402hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc .yiv0658632402ad {margin-bottom:10px;padding:0 0;}#yiv0658632402 #yiv0658632402actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0658632402 #yiv0658632402activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0658632402 #yiv0658632402activity span {font-weight:700;}#yiv0658632402 #yiv0658632402activity span:first-child {text-transform:uppercase;}#yiv0658632402 #yiv0658632402activity span a {color:#5085b6;text-decoration:none;}#yiv0658632402 #yiv0658632402activity span span {color:#ff7900;}#yiv0658632402 #yiv0658632402activity span .yiv0658632402underline {text-decoration:underline;}#yiv0658632402 .yiv0658632402attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0658632402 .yiv0658632402attach div a {text-decoration:none;}#yiv0658632402 .yiv0658632402attach img {border:none;padding-right:5px;}#yiv0658632402 .yiv0658632402attach label {display:block;margin-bottom:5px;}#yiv0658632402 .yiv0658632402attach label a {text-decoration:none;}#yiv0658632402 blockquote {margin:0 0 0 4px;}#yiv0658632402 .yiv0658632402bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0658632402 .yiv0658632402bold a {text-decoration:none;}#yiv0658632402 dd.yiv0658632402last p a {font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span...yiv0658632402yshortcuts {margin-right:0;}#yiv0658632402 div.yiv0658632402attach-table div div a {text-decoration:none;}#yiv0658632402 div.yiv0658632402attach-table {width:400px;}#yiv0658632402 div.yiv0658632402file-title a, #yiv0658632402 div.yiv0658632402file-title a:active, #yiv0658632402 div.yiv0658632402file-title a:hover, #yiv0658632402 div.yiv0658632402file-title a:visited {text-decoration:none;}#yiv0658632402 div.yiv0658632402photo-title a, #yiv0658632402 div.yiv0658632402photo-title a:active, #yiv0658632402 div...yiv0658632402photo-title a:hover, #yiv0658632402 div.yiv0658632402photo-title a:visited {text-decoration:none;}#yiv0658632402 div#yiv0658632402ygrp-mlmsg #yiv0658632402ygrp-msg p a span.yiv0658632402yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0658632402 .yiv0658632402green {color:#628c2a;}#yiv0658632402 .yiv0658632402MsoNormal {margin:0 0 0 0;}#yiv0658632402 o {font-size:0;}#yiv0658632402 #yiv0658632402photos div {float:left;width:72px;}#yiv0658632402 #yiv0658632402photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0658632402 #yiv0658632402photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0658632402 #yiv0658632402reco-category {font-size:77%;}#yiv0658632402 #yiv0658632402reco-desc {font-size:77%;}#yiv0658632402 .yiv0658632402replbq {margin:4px;}#yiv0658632402 #yiv0658632402ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0658632402 #yiv0658632402ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0658632402 #yiv0658632402ygrp-mlmsg select, #yiv0658632402 input, #yiv0658632402 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg pre, #yiv0658632402 code {font:115% monospace;}#yiv0658632402 #yiv0658632402ygrp-mlmsg * {line-height:1.22em;}#yiv0658632402 #yiv0658632402ygrp-mlmsg #yiv0658632402logo {padding-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-msg p a {font-family:Verdana;}#yiv0658632402 #yiv0658632402ygrp-msg p#yiv0658632402attach-count span {color:#1E66AE;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco #yiv0658632402reco-head {color:#ff7900;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li a {font-size:130%;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov ul {margin:0;padding:0 0 0 8px;}#yiv0658632402 #yiv0658632402ygrp-text {font-family:Georgia;}#yiv0658632402 #yiv0658632402ygrp-text p {margin:0 0 1em 0;}#yiv0658632402 #yiv0658632402ygrp-text tt {font-size:120%;}#yiv0658632402 #yiv0658632402ygrp-vital ul li:last-child {border-right:none !important;}#yiv0658632402