Hai Danny, Coba file ini, file ini bekerja dengan baik di computer saya. TerimaKasih.
Pada Kamis, 16 April 2015 8:52, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Justru Shape warna biru itu untuk menyalin sheet yang dipilih di dalam
userform pak. Jika sheet nya banyak, kita bisa memilih (di dalam userform)
untuk menyalin sheet yang kita inginkan. Di dalam contoh File, saya hanya
menyediakan 1 sheet saja. Begitu pak hehehe... #yiv0042889460 #yiv0042889460
-- #yiv0042889460ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0042889460
#yiv0042889460ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0042889460
#yiv0042889460ygrp-mkp #yiv0042889460hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0042889460 #yiv0042889460ygrp-mkp #yiv0042889460ads
{margin-bottom:10px;}#yiv0042889460 #yiv0042889460ygrp-mkp .yiv0042889460ad
{padding:0 0;}#yiv0042889460 #yiv0042889460ygrp-mkp .yiv0042889460ad p
{margin:0;}#yiv0042889460 #yiv0042889460ygrp-mkp .yiv0042889460ad a
{color:#0000ff;text-decoration:none;}#yiv0042889460 #yiv0042889460ygrp-sponsor
#yiv0042889460ygrp-lc {font-family:Arial;}#yiv0042889460
#yiv0042889460ygrp-sponsor #yiv0042889460ygrp-lc #yiv0042889460hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0042889460
#yiv0042889460ygrp-sponsor #yiv0042889460ygrp-lc .yiv0042889460ad
{margin-bottom:10px;padding:0 0;}#yiv0042889460 #yiv0042889460actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0042889460
#yiv0042889460activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0042889460
#yiv0042889460activity span {font-weight:700;}#yiv0042889460
#yiv0042889460activity span:first-child
{text-transform:uppercase;}#yiv0042889460 #yiv0042889460activity span a
{color:#5085b6;text-decoration:none;}#yiv0042889460 #yiv0042889460activity span
span {color:#ff7900;}#yiv0042889460 #yiv0042889460activity span
.yiv0042889460underline {text-decoration:underline;}#yiv0042889460
.yiv0042889460attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0042889460 .yiv0042889460attach div a
{text-decoration:none;}#yiv0042889460 .yiv0042889460attach img
{border:none;padding-right:5px;}#yiv0042889460 .yiv0042889460attach label
{display:block;margin-bottom:5px;}#yiv0042889460 .yiv0042889460attach label a
{text-decoration:none;}#yiv0042889460 blockquote {margin:0 0 0
4px;}#yiv0042889460 .yiv0042889460bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0042889460
.yiv0042889460bold a {text-decoration:none;}#yiv0042889460 dd.yiv0042889460last
p a {font-family:Verdana;font-weight:700;}#yiv0042889460 dd.yiv0042889460last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0042889460
dd.yiv0042889460last p span.yiv0042889460yshortcuts
{margin-right:0;}#yiv0042889460 div.yiv0042889460attach-table div div a
{text-decoration:none;}#yiv0042889460 div.yiv0042889460attach-table
{width:400px;}#yiv0042889460 div.yiv0042889460file-title a, #yiv0042889460
div.yiv0042889460file-title a:active, #yiv0042889460
div.yiv0042889460file-title a:hover, #yiv0042889460 div.yiv0042889460file-title
a:visited {text-decoration:none;}#yiv0042889460 div.yiv0042889460photo-title a,
#yiv0042889460 div.yiv0042889460photo-title a:active, #yiv0042889460
div.yiv0042889460photo-title a:hover, #yiv0042889460
div.yiv0042889460photo-title a:visited {text-decoration:none;}#yiv0042889460
div#yiv0042889460ygrp-mlmsg #yiv0042889460ygrp-msg p a
span.yiv0042889460yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0042889460
.yiv0042889460green {color:#628c2a;}#yiv0042889460 .yiv0042889460MsoNormal
{margin:0 0 0 0;}#yiv0042889460 o {font-size:0;}#yiv0042889460
#yiv0042889460photos div {float:left;width:72px;}#yiv0042889460
#yiv0042889460photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0042889460
#yiv0042889460photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0042889460
#yiv0042889460reco-category {font-size:77%;}#yiv0042889460
#yiv0042889460reco-desc {font-size:77%;}#yiv0042889460 .yiv0042889460replbq
{margin:4px;}#yiv0042889460 #yiv0042889460ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0042889460 #yiv0042889460ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0042889460
#yiv0042889460ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0042889460
#yiv0042889460ygrp-mlmsg select, #yiv0042889460 input, #yiv0042889460 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0042889460
#yiv0042889460ygrp-mlmsg pre, #yiv0042889460 code {font:115%
monospace;}#yiv0042889460 #yiv0042889460ygrp-mlmsg *
{line-height:1.22em;}#yiv0042889460 #yiv0042889460ygrp-mlmsg #yiv0042889460logo
{padding-bottom:10px;}#yiv0042889460 #yiv0042889460ygrp-msg p a
{font-family:Verdana;}#yiv0042889460 #yiv0042889460ygrp-msg
p#yiv0042889460attach-count span {color:#1E66AE;font-weight:700;}#yiv0042889460
#yiv0042889460ygrp-reco #yiv0042889460reco-head
{color:#ff7900;font-weight:700;}#yiv0042889460 #yiv0042889460ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0042889460 #yiv0042889460ygrp-sponsor
#yiv0042889460ov li a {font-size:130%;text-decoration:none;}#yiv0042889460
#yiv0042889460ygrp-sponsor #yiv0042889460ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0042889460
#yiv0042889460ygrp-sponsor #yiv0042889460ov ul {margin:0;padding:0 0 0
8px;}#yiv0042889460 #yiv0042889460ygrp-text
{font-family:Georgia;}#yiv0042889460 #yiv0042889460ygrp-text p {margin:0 0 1em
0;}#yiv0042889460 #yiv0042889460ygrp-text tt {font-size:120%;}#yiv0042889460
#yiv0042889460ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0042889460
Testing_toby.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
