Yth. Mr. Kid
Problemnya sama persis dg case saya dulu yang pernah saya tanyakan di milis
ini. file excel 2007, sudah di centang print object, ketika diprint preview dan
print, gambar tidak muncul ..
Sekian
Terima kasih
On Sunday, March 26, 2017 8:58 PM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Wa'alaikumussalam wr wb
Hai Kusnadi,
File lampiran Anda bisa berjalan dengan baik di versi 2007 ke atas.
Mungkin perlu diperiksa ulang apakah shapes wadah gambar masih memiliki formula
yang merujuk ke nama range tertentu ataukah tidak.
Biasanya, jika di-print preview telah ok, maka hasil printout juga ok.
Jika di print preview tidak tampak, coba periksa properti Print Object dalam
keadaan tercentang.
Properti Print Object diakses dengan cara :
klik kanan shape -> pilih Size and Propeties -> centang item Print Object -> OK
*** jika di klik kanan tidak ada pilihan Size and Properties : pilih Format
Picture -> klik tab Properties -> centang Print Object -> OK
Wassalamu'alaikum wr wb
Kid
2017-03-26 12:44 GMT+07:00 Kusnadi Bin zain kbinz...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
Dengan hormat
terlampir update foto secara otomatis dari data ke formulirsetiap perubahan
nomor di formulir, foto juga update otomatis
masalahnya, ternyata sheet formulir ini ketika dicetak/print fotonya jadi tidak
munculbagaimana caranya agar foto yg tercantum itu bisa juga dicetak
yg kedua saya menggunakan excell2007, ketika saya bawa ke rental yg memakai
excell2010ternyata tidak support, foto tetap tidak mau berubahpertanyaannya apa
memang begitu, apa ada cara lain update foto di excell2010
Terima kasih
Wassalam
Kusnadi
#yiv0079467723 #yiv0079467723 -- #yiv0079467723ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0079467723
#yiv0079467723ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0079467723
#yiv0079467723ygrp-mkp #yiv0079467723hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0079467723 #yiv0079467723ygrp-mkp #yiv0079467723ads
{margin-bottom:10px;}#yiv0079467723 #yiv0079467723ygrp-mkp .yiv0079467723ad
{padding:0 0;}#yiv0079467723 #yiv0079467723ygrp-mkp .yiv0079467723ad p
{margin:0;}#yiv0079467723 #yiv0079467723ygrp-mkp .yiv0079467723ad a
{color:#0000ff;text-decoration:none;}#yiv0079467723 #yiv0079467723ygrp-sponsor
#yiv0079467723ygrp-lc {font-family:Arial;}#yiv0079467723
#yiv0079467723ygrp-sponsor #yiv0079467723ygrp-lc #yiv0079467723hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0079467723
#yiv0079467723ygrp-sponsor #yiv0079467723ygrp-lc .yiv0079467723ad
{margin-bottom:10px;padding:0 0;}#yiv0079467723 #yiv0079467723actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0079467723
#yiv0079467723activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0079467723
#yiv0079467723activity span {font-weight:700;}#yiv0079467723
#yiv0079467723activity span:first-child
{text-transform:uppercase;}#yiv0079467723 #yiv0079467723activity span a
{color:#5085b6;text-decoration:none;}#yiv0079467723 #yiv0079467723activity span
span {color:#ff7900;}#yiv0079467723 #yiv0079467723activity span
.yiv0079467723underline {text-decoration:underline;}#yiv0079467723
.yiv0079467723attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0079467723 .yiv0079467723attach div a
{text-decoration:none;}#yiv0079467723 .yiv0079467723attach img
{border:none;padding-right:5px;}#yiv0079467723 .yiv0079467723attach label
{display:block;margin-bottom:5px;}#yiv0079467723 .yiv0079467723attach label a
{text-decoration:none;}#yiv0079467723 blockquote {margin:0 0 0
4px;}#yiv0079467723 .yiv0079467723bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0079467723
.yiv0079467723bold a {text-decoration:none;}#yiv0079467723 dd.yiv0079467723last
p a {font-family:Verdana;font-weight:700;}#yiv0079467723 dd.yiv0079467723last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0079467723
dd.yiv0079467723last p span.yiv0079467723yshortcuts
{margin-right:0;}#yiv0079467723 div.yiv0079467723attach-table div div a
{text-decoration:none;}#yiv0079467723 div.yiv0079467723attach-table
{width:400px;}#yiv0079467723 div.yiv0079467723file-title a, #yiv0079467723
div.yiv0079467723file-title a:active, #yiv0079467723
div.yiv0079467723file-title a:hover, #yiv0079467723 div.yiv0079467723file-title
a:visited {text-decoration:none;}#yiv0079467723 div.yiv0079467723photo-title a,
#yiv0079467723 div.yiv0079467723photo-title a:active, #yiv0079467723
div.yiv0079467723photo-title a:hover, #yiv0079467723
div.yiv0079467723photo-title a:visited {text-decoration:none;}#yiv0079467723
div#yiv0079467723ygrp-mlmsg #yiv0079467723ygrp-msg p a
span.yiv0079467723yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0079467723
.yiv0079467723green {color:#628c2a;}#yiv0079467723 .yiv0079467723MsoNormal
{margin:0 0 0 0;}#yiv0079467723 o {font-size:0;}#yiv0079467723
#yiv0079467723photos div {float:left;width:72px;}#yiv0079467723
#yiv0079467723photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0079467723
#yiv0079467723photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0079467723
#yiv0079467723reco-category {font-size:77%;}#yiv0079467723
#yiv0079467723reco-desc {font-size:77%;}#yiv0079467723 .yiv0079467723replbq
{margin:4px;}#yiv0079467723 #yiv0079467723ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0079467723 #yiv0079467723ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0079467723
#yiv0079467723ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0079467723
#yiv0079467723ygrp-mlmsg select, #yiv0079467723 input, #yiv0079467723 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0079467723
#yiv0079467723ygrp-mlmsg pre, #yiv0079467723 code {font:115%
monospace;}#yiv0079467723 #yiv0079467723ygrp-mlmsg *
{line-height:1.22em;}#yiv0079467723 #yiv0079467723ygrp-mlmsg #yiv0079467723logo
{padding-bottom:10px;}#yiv0079467723 #yiv0079467723ygrp-msg p a
{font-family:Verdana;}#yiv0079467723 #yiv0079467723ygrp-msg
p#yiv0079467723attach-count span {color:#1E66AE;font-weight:700;}#yiv0079467723
#yiv0079467723ygrp-reco #yiv0079467723reco-head
{color:#ff7900;font-weight:700;}#yiv0079467723 #yiv0079467723ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0079467723 #yiv0079467723ygrp-sponsor
#yiv0079467723ov li a {font-size:130%;text-decoration:none;}#yiv0079467723
#yiv0079467723ygrp-sponsor #yiv0079467723ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0079467723
#yiv0079467723ygrp-sponsor #yiv0079467723ov ul {margin:0;padding:0 0 0
8px;}#yiv0079467723 #yiv0079467723ygrp-text
{font-family:Georgia;}#yiv0079467723 #yiv0079467723ygrp-text p {margin:0 0 1em
0;}#yiv0079467723 #yiv0079467723ygrp-text tt {font-size:120%;}#yiv0079467723
#yiv0079467723ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0079467723
