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