Coba file terlampir, apakah sudah sesuai dengan kebutuhan....
Salam,HK
From: "violin cello [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Sunday, 28 December 2014, 10:56
Subject: [belajar-excel] memunculkan sheet secara bergantian [1 Attachment]
Dear para master,
bagaimana memunculkan sheet secara bergantian dengan macro dan menggunakan
xlsheetveryhidden
jika saya memilih sheet1 maka seluruh sheet akan dixlsheetveryhidden termasuk
menu utama...
biar jelas langsung ke TKP aja gan #yiv9062736655 #yiv9062736655 --
#yiv9062736655ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv9062736655 #yiv9062736655ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9062736655 #yiv9062736655ygrp-mkp #yiv9062736655hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9062736655 #yiv9062736655ygrp-mkp #yiv9062736655ads
{margin-bottom:10px;}#yiv9062736655 #yiv9062736655ygrp-mkp .yiv9062736655ad
{padding:0 0;}#yiv9062736655 #yiv9062736655ygrp-mkp .yiv9062736655ad p
{margin:0;}#yiv9062736655 #yiv9062736655ygrp-mkp .yiv9062736655ad a
{color:#0000ff;text-decoration:none;}#yiv9062736655 #yiv9062736655ygrp-sponsor
#yiv9062736655ygrp-lc {font-family:Arial;}#yiv9062736655
#yiv9062736655ygrp-sponsor #yiv9062736655ygrp-lc #yiv9062736655hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9062736655
#yiv9062736655ygrp-sponsor #yiv9062736655ygrp-lc .yiv9062736655ad
{margin-bottom:10px;padding:0 0;}#yiv9062736655 #yiv9062736655actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9062736655
#yiv9062736655activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9062736655
#yiv9062736655activity span {font-weight:700;}#yiv9062736655
#yiv9062736655activity span:first-child
{text-transform:uppercase;}#yiv9062736655 #yiv9062736655activity span a
{color:#5085b6;text-decoration:none;}#yiv9062736655 #yiv9062736655activity span
span {color:#ff7900;}#yiv9062736655 #yiv9062736655activity span
.yiv9062736655underline {text-decoration:underline;}#yiv9062736655
.yiv9062736655attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9062736655 .yiv9062736655attach div a
{text-decoration:none;}#yiv9062736655 .yiv9062736655attach img
{border:none;padding-right:5px;}#yiv9062736655 .yiv9062736655attach label
{display:block;margin-bottom:5px;}#yiv9062736655 .yiv9062736655attach label a
{text-decoration:none;}#yiv9062736655 blockquote {margin:0 0 0
4px;}#yiv9062736655 .yiv9062736655bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9062736655
.yiv9062736655bold a {text-decoration:none;}#yiv9062736655 dd.yiv9062736655last
p a {font-family:Verdana;font-weight:700;}#yiv9062736655 dd.yiv9062736655last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9062736655
dd.yiv9062736655last p span.yiv9062736655yshortcuts
{margin-right:0;}#yiv9062736655 div.yiv9062736655attach-table div div a
{text-decoration:none;}#yiv9062736655 div.yiv9062736655attach-table
{width:400px;}#yiv9062736655 div.yiv9062736655file-title a, #yiv9062736655
div.yiv9062736655file-title a:active, #yiv9062736655
div.yiv9062736655file-title a:hover, #yiv9062736655 div.yiv9062736655file-title
a:visited {text-decoration:none;}#yiv9062736655 div.yiv9062736655photo-title a,
#yiv9062736655 div.yiv9062736655photo-title a:active, #yiv9062736655
div.yiv9062736655photo-title a:hover, #yiv9062736655
div.yiv9062736655photo-title a:visited {text-decoration:none;}#yiv9062736655
div#yiv9062736655ygrp-mlmsg #yiv9062736655ygrp-msg p a
span.yiv9062736655yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9062736655
.yiv9062736655green {color:#628c2a;}#yiv9062736655 .yiv9062736655MsoNormal
{margin:0 0 0 0;}#yiv9062736655 o {font-size:0;}#yiv9062736655
#yiv9062736655photos div {float:left;width:72px;}#yiv9062736655
#yiv9062736655photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9062736655
#yiv9062736655photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9062736655
#yiv9062736655reco-category {font-size:77%;}#yiv9062736655
#yiv9062736655reco-desc {font-size:77%;}#yiv9062736655 .yiv9062736655replbq
{margin:4px;}#yiv9062736655 #yiv9062736655ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9062736655 #yiv9062736655ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9062736655
#yiv9062736655ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9062736655
#yiv9062736655ygrp-mlmsg select, #yiv9062736655 input, #yiv9062736655 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9062736655
#yiv9062736655ygrp-mlmsg pre, #yiv9062736655 code {font:115%
monospace;}#yiv9062736655 #yiv9062736655ygrp-mlmsg *
{line-height:1.22em;}#yiv9062736655 #yiv9062736655ygrp-mlmsg #yiv9062736655logo
{padding-bottom:10px;}#yiv9062736655 #yiv9062736655ygrp-msg p a
{font-family:Verdana;}#yiv9062736655 #yiv9062736655ygrp-msg
p#yiv9062736655attach-count span {color:#1E66AE;font-weight:700;}#yiv9062736655
#yiv9062736655ygrp-reco #yiv9062736655reco-head
{color:#ff7900;font-weight:700;}#yiv9062736655 #yiv9062736655ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9062736655 #yiv9062736655ygrp-sponsor
#yiv9062736655ov li a {font-size:130%;text-decoration:none;}#yiv9062736655
#yiv9062736655ygrp-sponsor #yiv9062736655ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9062736655
#yiv9062736655ygrp-sponsor #yiv9062736655ov ul {margin:0;padding:0 0 0
8px;}#yiv9062736655 #yiv9062736655ygrp-text
{font-family:Georgia;}#yiv9062736655 #yiv9062736655ygrp-text p {margin:0 0 1em
0;}#yiv9062736655 #yiv9062736655ygrp-text tt {font-size:120%;}#yiv9062736655
#yiv9062736655ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9062736655 
re_gonta ganti sheet.xls
Description: MS-Excel spreadsheet
