Terima kasih mas Agus dan Pak Hendrik atas jawabannya setelah saya coba berhasil.. salam sukses semua
"hendrik karnadi [email protected] [belajar-excel]" <[email protected]> menulis: >Maaf, di VBE workbookpun perlu ditambahkan Macro ini, >Private Sub Workbook_BeforeClose(Cancel As Boolean) >Application.DisplayFullScreen = FalseEnd Sub >Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) > Application.DisplayFullScreen = FalseEnd Sub >agar file lain tidak terpengaruh. >Nama filenya re_contoh (R). > >Salam,HK > > ----- Forwarded Message ----- > From: "hendrik karnadi [email protected] [belajar-excel]" > <[email protected]> > To: "[email protected]" <[email protected]> > Sent: Saturday, 27 December 2014, 20:47 > Subject: Fw: Fwd: Re: [belajar-excel] sembunyikan toolbar [1 Attachment] > > Hai Yudha,Pinjam filenya Pak Agus, barangkali seperti ini macro yang harus >ditulis di VBE Sheet1 (Macro di VBE Sheets lainnya saya hapus), >Private Sub Worksheet_Activate() Application.DisplayFullScreen = TrueEnd Sub >Private Sub Worksheet_Deactivate() Application.DisplayFullScreen = FalseEnd >Sub >Nama filenya re_contoh >Salam,HK > > > > ----- Forwarded Message ----- > From: "Hendrik Karnadi [email protected] [belajar-excel]" > <[email protected]> > To: [email protected] > Sent: Saturday, 27 December 2014, 18:34 > Subject: Fwd: Re: [belajar-excel] sembunyikan toolbar > > Sdh coba pake rekaman macro pak ?Dengan even worksheet_activate,jika >Sheet1 diaktifkan maka Sheet1 jadi fullscreen tetapi jika sheets lain yang >diaktifkan (worksheet_deactivate) maka sheets menjadi normal. >Salam,HK > >Sent from Samsung Mobile > >-------- Original message --------From: "yudha [email protected] >[belajar-excel]" Date:27/12/2014 10:17 (GMT+07:00) To: "Nang Agus >[email protected] [belajar-excel]" Subject: Re: [belajar-excel] sembunyikan >toolbar > Terima kasih mas Agus atas responnya >tapi kok setelah file dari mas agus saya buka, malah semua file jadi >fullscreen semua ya.. >Yudha > >"Nang Agus [email protected] [belajar-excel]" <[email protected]> >menulis: > >>Bagaimana jika sheet1 di Fullscreen saja, jadi seolaholah tollbar tidak ada >>karena difullscreen. >>lihat contoh! >> >>2014-12-26 12:40 GMT+07:00 yudha [email protected] >>[belajar-excel] <[email protected]>: >> >>> >>> >>> Siang Master >>> mau nanya nih.. >>> bagaimana caranya untuk menyembunyikan toolbar, tapi hanya disalah satu >>> sheet saja >>> misal kita punya file dgn 10 sheet dan inginnya hanya sheet1 saja yg >>> toolbarnya sembunyi..sedangkan sheet yg lain toolbarnya tetep ada >>> trims >>> Yudha >>> >>> > > > #yiv0247785711 #yiv0247785711 -- #yiv0247785711ygrp-mkp {border:1px solid > #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0247785711 > #yiv0247785711ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0247785711 > #yiv0247785711ygrp-mkp #yiv0247785711hd > {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;}#yiv0247785711 #yiv0247785711ygrp-mkp #yiv0247785711ads > {margin-bottom:10px;}#yiv0247785711 #yiv0247785711ygrp-mkp .yiv0247785711ad > {padding:0 0;}#yiv0247785711 #yiv0247785711ygrp-mkp .yiv0247785711ad p > {margin:0;}#yiv0247785711 #yiv0247785711ygrp-mkp .yiv0247785711ad a > {color:#0000ff;text-decoration:none;}#yiv0247785711 > #yiv0247785711ygrp-sponsor #yiv0247785711ygrp-lc > {font-family:Arial;}#yiv0247785711 #yiv0247785711ygrp-sponsor > #yiv0247785711ygrp-lc #yiv0247785711hd {margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0247785711 > #yiv0247785711ygrp-sponsor #yiv0247785711ygrp-lc .yiv0247785711ad > {margin-bottom:10px;padding:0 0;}#yiv0247785711 #yiv0247785711actions > {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0247785711 > #yiv0247785711activity > {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0247785711 > #yiv0247785711activity span {font-weight:700;}#yiv0247785711 > #yiv0247785711activity span:first-child > {text-transform:uppercase;}#yiv0247785711 #yiv0247785711activity span a > {color:#5085b6;text-decoration:none;}#yiv0247785711 #yiv0247785711activity > span span {color:#ff7900;}#yiv0247785711 #yiv0247785711activity span > .yiv0247785711underline {text-decoration:underline;}#yiv0247785711 > .yiv0247785711attach > {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;}#yiv0247785711 .yiv0247785711attach div a > {text-decoration:none;}#yiv0247785711 .yiv0247785711attach img > {border:none;padding-right:5px;}#yiv0247785711 .yiv0247785711attach label > {display:block;margin-bottom:5px;}#yiv0247785711 .yiv0247785711attach label a > {text-decoration:none;}#yiv0247785711 blockquote {margin:0 0 0 > 4px;}#yiv0247785711 .yiv0247785711bold > {font-family:Arial;font-size:13px;font-weight:700;}#yiv0247785711 > .yiv0247785711bold a {text-decoration:none;}#yiv0247785711 > dd.yiv0247785711last p a {font-family:Verdana;font-weight:700;}#yiv0247785711 > dd.yiv0247785711last p span > {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0247785711 > dd.yiv0247785711last p span.yiv0247785711yshortcuts > {margin-right:0;}#yiv0247785711 div.yiv0247785711attach-table div div a > {text-decoration:none;}#yiv0247785711 div.yiv0247785711attach-table > {width:400px;}#yiv0247785711 div.yiv0247785711file-title a, #yiv0247785711 > div.yiv0247785711file-title a:active, #yiv0247785711 > div.yiv0247785711file-title a:hover, #yiv0247785711 > div.yiv0247785711file-title a:visited {text-decoration:none;}#yiv0247785711 > div.yiv0247785711photo-title a, #yiv0247785711 div.yiv0247785711photo-title > a:active, #yiv0247785711 div.yiv0247785711photo-title a:hover, #yiv0247785711 > div.yiv0247785711photo-title a:visited {text-decoration:none;}#yiv0247785711 > div#yiv0247785711ygrp-mlmsg #yiv0247785711ygrp-msg p a > span.yiv0247785711yshortcuts > {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0247785711 > .yiv0247785711green {color:#628c2a;}#yiv0247785711 .yiv0247785711MsoNormal > {margin:0 0 0 0;}#yiv0247785711 o {font-size:0;}#yiv0247785711 > #yiv0247785711photos div {float:left;width:72px;}#yiv0247785711 > #yiv0247785711photos div div {border:1px solid > #666666;height:62px;overflow:hidden;width:62px;}#yiv0247785711 > #yiv0247785711photos div label > {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0247785711 > #yiv0247785711reco-category {font-size:77%;}#yiv0247785711 > #yiv0247785711reco-desc {font-size:77%;}#yiv0247785711 .yiv0247785711replbq > {margin:4px;}#yiv0247785711 #yiv0247785711ygrp-actbar div a:first-child > {margin-right:2px;padding-right:5px;}#yiv0247785711 #yiv0247785711ygrp-mlmsg > {font-size:13px;font-family:Arial, helvetica, clean, > sans-serif;}#yiv0247785711 #yiv0247785711ygrp-mlmsg table > {font-size:inherit;font:100%;}#yiv0247785711 #yiv0247785711ygrp-mlmsg select, > #yiv0247785711 input, #yiv0247785711 textarea {font:99% Arial, Helvetica, > clean, sans-serif;}#yiv0247785711 #yiv0247785711ygrp-mlmsg pre, > #yiv0247785711 code {font:115% monospace;}#yiv0247785711 > #yiv0247785711ygrp-mlmsg * {line-height:1.22em;}#yiv0247785711 > #yiv0247785711ygrp-mlmsg #yiv0247785711logo > {padding-bottom:10px;}#yiv0247785711 #yiv0247785711ygrp-msg p a > {font-family:Verdana;}#yiv0247785711 #yiv0247785711ygrp-msg > p#yiv0247785711attach-count span > {color:#1E66AE;font-weight:700;}#yiv0247785711 #yiv0247785711ygrp-reco > #yiv0247785711reco-head {color:#ff7900;font-weight:700;}#yiv0247785711 > #yiv0247785711ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0247785711 > #yiv0247785711ygrp-sponsor #yiv0247785711ov li a > {font-size:130%;text-decoration:none;}#yiv0247785711 > #yiv0247785711ygrp-sponsor #yiv0247785711ov li > {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0247785711 > #yiv0247785711ygrp-sponsor #yiv0247785711ov ul {margin:0;padding:0 0 0 > 8px;}#yiv0247785711 #yiv0247785711ygrp-text > {font-family:Georgia;}#yiv0247785711 #yiv0247785711ygrp-text p {margin:0 0 > 1em 0;}#yiv0247785711 #yiv0247785711ygrp-text tt > {font-size:120%;}#yiv0247785711 #yiv0247785711ygrp-vital ul li:last-child > {border-right:none !important;}#yiv0247785711 > >
