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 >> >> #yiv2266554502 -- #yiv2266554502ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2266554502 #yiv2266554502ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2266554502 #yiv2266554502ygrp-mkp #yiv2266554502hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2266554502 #yiv2266554502ygrp-mkp #yiv2266554502ads {margin-bottom:10px;}#yiv2266554502 #yiv2266554502ygrp-mkp .yiv2266554502ad {padding:0 0;}#yiv2266554502 #yiv2266554502ygrp-mkp .yiv2266554502ad p {margin:0;}#yiv2266554502 #yiv2266554502ygrp-mkp .yiv2266554502ad a {color:#0000ff;text-decoration:none;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ygrp-lc {font-family:Arial;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ygrp-lc #yiv2266554502hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ygrp-lc .yiv2266554502ad {margin-bottom:10px;padding:0 0;}#yiv2266554502 #yiv2266554502actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2266554502 #yiv2266554502activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2266554502 #yiv2266554502activity span {font-weight:700;}#yiv2266554502 #yiv2266554502activity span:first-child {text-transform:uppercase;}#yiv2266554502 #yiv2266554502activity span a {color:#5085b6;text-decoration:none;}#yiv2266554502 #yiv2266554502activity span span {color:#ff7900;}#yiv2266554502 #yiv2266554502activity span .yiv2266554502underline {text-decoration:underline;}#yiv2266554502 .yiv2266554502attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2266554502 .yiv2266554502attach div a {text-decoration:none;}#yiv2266554502 .yiv2266554502attach img {border:none;padding-right:5px;}#yiv2266554502 .yiv2266554502attach label {display:block;margin-bottom:5px;}#yiv2266554502 .yiv2266554502attach label a {text-decoration:none;}#yiv2266554502 blockquote {margin:0 0 0 4px;}#yiv2266554502 .yiv2266554502bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2266554502 .yiv2266554502bold a {text-decoration:none;}#yiv2266554502 dd.yiv2266554502last p a {font-family:Verdana;font-weight:700;}#yiv2266554502 dd.yiv2266554502last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2266554502 dd.yiv2266554502last p span.yiv2266554502yshortcuts {margin-right:0;}#yiv2266554502 div.yiv2266554502attach-table div div a {text-decoration:none;}#yiv2266554502 div.yiv2266554502attach-table {width:400px;}#yiv2266554502 div.yiv2266554502file-title a, #yiv2266554502 div.yiv2266554502file-title a:active, #yiv2266554502 div.yiv2266554502file-title a:hover, #yiv2266554502 div.yiv2266554502file-title a:visited {text-decoration:none;}#yiv2266554502 div.yiv2266554502photo-title a, #yiv2266554502 div.yiv2266554502photo-title a:active, #yiv2266554502 div.yiv2266554502photo-title a:hover, #yiv2266554502 div.yiv2266554502photo-title a:visited {text-decoration:none;}#yiv2266554502 div#yiv2266554502ygrp-mlmsg #yiv2266554502ygrp-msg p a span.yiv2266554502yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2266554502 .yiv2266554502green {color:#628c2a;}#yiv2266554502 .yiv2266554502MsoNormal {margin:0 0 0 0;}#yiv2266554502 o {font-size:0;}#yiv2266554502 #yiv2266554502photos div {float:left;width:72px;}#yiv2266554502 #yiv2266554502photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2266554502 #yiv2266554502photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2266554502 #yiv2266554502reco-category {font-size:77%;}#yiv2266554502 #yiv2266554502reco-desc {font-size:77%;}#yiv2266554502 .yiv2266554502replbq {margin:4px;}#yiv2266554502 #yiv2266554502ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2266554502 #yiv2266554502ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2266554502 #yiv2266554502ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2266554502 #yiv2266554502ygrp-mlmsg select, #yiv2266554502 input, #yiv2266554502 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2266554502 #yiv2266554502ygrp-mlmsg pre, #yiv2266554502 code {font:115% monospace;}#yiv2266554502 #yiv2266554502ygrp-mlmsg * {line-height:1.22em;}#yiv2266554502 #yiv2266554502ygrp-mlmsg #yiv2266554502logo {padding-bottom:10px;}#yiv2266554502 #yiv2266554502ygrp-msg p a {font-family:Verdana;}#yiv2266554502 #yiv2266554502ygrp-msg p#yiv2266554502attach-count span {color:#1E66AE;font-weight:700;}#yiv2266554502 #yiv2266554502ygrp-reco #yiv2266554502reco-head {color:#ff7900;font-weight:700;}#yiv2266554502 #yiv2266554502ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ov li a {font-size:130%;text-decoration:none;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2266554502 #yiv2266554502ygrp-sponsor #yiv2266554502ov ul {margin:0;padding:0 0 0 8px;}#yiv2266554502 #yiv2266554502ygrp-text {font-family:Georgia;}#yiv2266554502 #yiv2266554502ygrp-text p {margin:0 0 1em 0;}#yiv2266554502 #yiv2266554502ygrp-text tt {font-size:120%;}#yiv2266554502 #yiv2266554502ygrp-vital ul li:last-child {border-right:none !important;}#yiv2266554502
re_contoh.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
