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 [email protected]
[belajar-excel] <[email protected]> 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 [email protected] [belajar-excel]
Sent: Tuesday, July 30, 2019 7:47 AM
To: [email protected]
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
