Dear Farud,
1. Anda harus set picture sebagai logo dengan ukuran yang sama (misalnya 500 X
500 Pxl)2. Gunakan Format jpeg untuk picture yg sebagai logo (atau bisa yang
lain asal dengan ukuran picture yang sama)3. Coba script di bawah ini, masukan
dalam Module :
Sub insertpic()Dim FiletoopenDim pic As Object
Filetoopen = Application.GetOpenFilename("Picture File(*.jpg), *.jpg,(*.png),
*.png", , "Insert Picture", , False)
With Sheet1.Range("G4").Select.RowHeight = 169.ColumnWidth = 30.4End WithSet
pic = ActiveSheet.Pictures.Insert(Filetoopen)
End sub
TerimaKasih.
Pada Minggu, 23 Oktober 2016 15:25, "farud oke farud....@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Assalamualaikummohon bantuan para master sekaliansaya sudah googling cara
ganti logo dengan button dan sudah saya coba,tapi yang jadi masalah gambarnya
tidak sesuai dengan ukuran sell yang di inginkan.untuk lebih jelasnya saya
lampirkan filenyaatas bantuannya saya ucapkan banyak2 terimakasih
#yiv4967661062 #yiv4967661062 -- #yiv4967661062ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4967661062
#yiv4967661062ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4967661062
#yiv4967661062ygrp-mkp #yiv4967661062hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4967661062 #yiv4967661062ygrp-mkp #yiv4967661062ads
{margin-bottom:10px;}#yiv4967661062 #yiv4967661062ygrp-mkp .yiv4967661062ad
{padding:0 0;}#yiv4967661062 #yiv4967661062ygrp-mkp .yiv4967661062ad p
{margin:0;}#yiv4967661062 #yiv4967661062ygrp-mkp .yiv4967661062ad a
{color:#0000ff;text-decoration:none;}#yiv4967661062 #yiv4967661062ygrp-sponsor
#yiv4967661062ygrp-lc {font-family:Arial;}#yiv4967661062
#yiv4967661062ygrp-sponsor #yiv4967661062ygrp-lc #yiv4967661062hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4967661062
#yiv4967661062ygrp-sponsor #yiv4967661062ygrp-lc .yiv4967661062ad
{margin-bottom:10px;padding:0 0;}#yiv4967661062 #yiv4967661062actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4967661062
#yiv4967661062activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4967661062
#yiv4967661062activity span {font-weight:700;}#yiv4967661062
#yiv4967661062activity span:first-child
{text-transform:uppercase;}#yiv4967661062 #yiv4967661062activity span a
{color:#5085b6;text-decoration:none;}#yiv4967661062 #yiv4967661062activity span
span {color:#ff7900;}#yiv4967661062 #yiv4967661062activity span
.yiv4967661062underline {text-decoration:underline;}#yiv4967661062
.yiv4967661062attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4967661062 .yiv4967661062attach div a
{text-decoration:none;}#yiv4967661062 .yiv4967661062attach img
{border:none;padding-right:5px;}#yiv4967661062 .yiv4967661062attach label
{display:block;margin-bottom:5px;}#yiv4967661062 .yiv4967661062attach label a
{text-decoration:none;}#yiv4967661062 blockquote {margin:0 0 0
4px;}#yiv4967661062 .yiv4967661062bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4967661062
.yiv4967661062bold a {text-decoration:none;}#yiv4967661062 dd.yiv4967661062last
p a {font-family:Verdana;font-weight:700;}#yiv4967661062 dd.yiv4967661062last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4967661062
dd.yiv4967661062last p span.yiv4967661062yshortcuts
{margin-right:0;}#yiv4967661062 div.yiv4967661062attach-table div div a
{text-decoration:none;}#yiv4967661062 div.yiv4967661062attach-table
{width:400px;}#yiv4967661062 div.yiv4967661062file-title a, #yiv4967661062
div.yiv4967661062file-title a:active, #yiv4967661062
div.yiv4967661062file-title a:hover, #yiv4967661062 div.yiv4967661062file-title
a:visited {text-decoration:none;}#yiv4967661062 div.yiv4967661062photo-title a,
#yiv4967661062 div.yiv4967661062photo-title a:active, #yiv4967661062
div.yiv4967661062photo-title a:hover, #yiv4967661062
div.yiv4967661062photo-title a:visited {text-decoration:none;}#yiv4967661062
div#yiv4967661062ygrp-mlmsg #yiv4967661062ygrp-msg p a
span.yiv4967661062yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4967661062
.yiv4967661062green {color:#628c2a;}#yiv4967661062 .yiv4967661062MsoNormal
{margin:0 0 0 0;}#yiv4967661062 o {font-size:0;}#yiv4967661062
#yiv4967661062photos div {float:left;width:72px;}#yiv4967661062
#yiv4967661062photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4967661062
#yiv4967661062photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4967661062
#yiv4967661062reco-category {font-size:77%;}#yiv4967661062
#yiv4967661062reco-desc {font-size:77%;}#yiv4967661062 .yiv4967661062replbq
{margin:4px;}#yiv4967661062 #yiv4967661062ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4967661062 #yiv4967661062ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4967661062
#yiv4967661062ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4967661062
#yiv4967661062ygrp-mlmsg select, #yiv4967661062 input, #yiv4967661062 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4967661062
#yiv4967661062ygrp-mlmsg pre, #yiv4967661062 code {font:115%
monospace;}#yiv4967661062 #yiv4967661062ygrp-mlmsg *
{line-height:1.22em;}#yiv4967661062 #yiv4967661062ygrp-mlmsg #yiv4967661062logo
{padding-bottom:10px;}#yiv4967661062 #yiv4967661062ygrp-msg p a
{font-family:Verdana;}#yiv4967661062 #yiv4967661062ygrp-msg
p#yiv4967661062attach-count span {color:#1E66AE;font-weight:700;}#yiv4967661062
#yiv4967661062ygrp-reco #yiv4967661062reco-head
{color:#ff7900;font-weight:700;}#yiv4967661062 #yiv4967661062ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4967661062 #yiv4967661062ygrp-sponsor
#yiv4967661062ov li a {font-size:130%;text-decoration:none;}#yiv4967661062
#yiv4967661062ygrp-sponsor #yiv4967661062ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4967661062
#yiv4967661062ygrp-sponsor #yiv4967661062ov ul {margin:0;padding:0 0 0
8px;}#yiv4967661062 #yiv4967661062ygrp-text
{font-family:Georgia;}#yiv4967661062 #yiv4967661062ygrp-text p {margin:0 0 1em
0;}#yiv4967661062 #yiv4967661062ygrp-text tt {font-size:120%;}#yiv4967661062
#yiv4967661062ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4967661062
