Terlampir file yang saya ambil dari buku saya.Pwdnya saya ganti : "maseagus"
(tanpa apostrop).
Jangan lupa aktifkan macronya.
Pada saat file dibuka yang tampil hanya Sheet1.Jika ingin membuka Sheet lainnya
maka anda harus menjalankan macro Buka dan memasukkan Pwd di atas.
Pada saat file disave/ditutup maka tampilan dikembalikan ke Sheet1.
Semoga sesuai kebutuhan.
SalamHK
From: "Mase Agus [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 29 April 2015, 4:29
Subject: [belajar-excel] pertanyaan
Assalamu'alaikum
Saya belajar membuat aplikasi raport sederhana yang terdiri dari : sheet 1
:menu navigasi sheet 2 : data siswa sheet 3 : daftar nilai dan setrusya
keinginan saya adalah yang terlihat di tampilan adalah sheet 1 saja yang lain
tidak terlihat (tersembunyi). bagaiman cara membuat aplikasi tersebut ? mohon
pencerahannya terima kasih
#yiv0403279266 #yiv0403279266 -- #yiv0403279266ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0403279266
#yiv0403279266ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0403279266
#yiv0403279266ygrp-mkp #yiv0403279266hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0403279266 #yiv0403279266ygrp-mkp #yiv0403279266ads
{margin-bottom:10px;}#yiv0403279266 #yiv0403279266ygrp-mkp .yiv0403279266ad
{padding:0 0;}#yiv0403279266 #yiv0403279266ygrp-mkp .yiv0403279266ad p
{margin:0;}#yiv0403279266 #yiv0403279266ygrp-mkp .yiv0403279266ad a
{color:#0000ff;text-decoration:none;}#yiv0403279266 #yiv0403279266ygrp-sponsor
#yiv0403279266ygrp-lc {font-family:Arial;}#yiv0403279266
#yiv0403279266ygrp-sponsor #yiv0403279266ygrp-lc #yiv0403279266hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0403279266
#yiv0403279266ygrp-sponsor #yiv0403279266ygrp-lc .yiv0403279266ad
{margin-bottom:10px;padding:0 0;}#yiv0403279266 #yiv0403279266actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0403279266
#yiv0403279266activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0403279266
#yiv0403279266activity span {font-weight:700;}#yiv0403279266
#yiv0403279266activity span:first-child
{text-transform:uppercase;}#yiv0403279266 #yiv0403279266activity span a
{color:#5085b6;text-decoration:none;}#yiv0403279266 #yiv0403279266activity span
span {color:#ff7900;}#yiv0403279266 #yiv0403279266activity span
.yiv0403279266underline {text-decoration:underline;}#yiv0403279266
.yiv0403279266attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0403279266 .yiv0403279266attach div a
{text-decoration:none;}#yiv0403279266 .yiv0403279266attach img
{border:none;padding-right:5px;}#yiv0403279266 .yiv0403279266attach label
{display:block;margin-bottom:5px;}#yiv0403279266 .yiv0403279266attach label a
{text-decoration:none;}#yiv0403279266 blockquote {margin:0 0 0
4px;}#yiv0403279266 .yiv0403279266bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0403279266
.yiv0403279266bold a {text-decoration:none;}#yiv0403279266 dd.yiv0403279266last
p a {font-family:Verdana;font-weight:700;}#yiv0403279266 dd.yiv0403279266last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0403279266
dd.yiv0403279266last p span.yiv0403279266yshortcuts
{margin-right:0;}#yiv0403279266 div.yiv0403279266attach-table div div a
{text-decoration:none;}#yiv0403279266 div.yiv0403279266attach-table
{width:400px;}#yiv0403279266 div.yiv0403279266file-title a, #yiv0403279266
div.yiv0403279266file-title a:active, #yiv0403279266
div.yiv0403279266file-title a:hover, #yiv0403279266 div.yiv0403279266file-title
a:visited {text-decoration:none;}#yiv0403279266 div.yiv0403279266photo-title a,
#yiv0403279266 div.yiv0403279266photo-title a:active, #yiv0403279266
div.yiv0403279266photo-title a:hover, #yiv0403279266
div.yiv0403279266photo-title a:visited {text-decoration:none;}#yiv0403279266
div#yiv0403279266ygrp-mlmsg #yiv0403279266ygrp-msg p a
span.yiv0403279266yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0403279266
.yiv0403279266green {color:#628c2a;}#yiv0403279266 .yiv0403279266MsoNormal
{margin:0 0 0 0;}#yiv0403279266 o {font-size:0;}#yiv0403279266
#yiv0403279266photos div {float:left;width:72px;}#yiv0403279266
#yiv0403279266photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0403279266
#yiv0403279266photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0403279266
#yiv0403279266reco-category {font-size:77%;}#yiv0403279266
#yiv0403279266reco-desc {font-size:77%;}#yiv0403279266 .yiv0403279266replbq
{margin:4px;}#yiv0403279266 #yiv0403279266ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0403279266 #yiv0403279266ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0403279266
#yiv0403279266ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0403279266
#yiv0403279266ygrp-mlmsg select, #yiv0403279266 input, #yiv0403279266 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0403279266
#yiv0403279266ygrp-mlmsg pre, #yiv0403279266 code {font:115%
monospace;}#yiv0403279266 #yiv0403279266ygrp-mlmsg *
{line-height:1.22em;}#yiv0403279266 #yiv0403279266ygrp-mlmsg #yiv0403279266logo
{padding-bottom:10px;}#yiv0403279266 #yiv0403279266ygrp-msg p a
{font-family:Verdana;}#yiv0403279266 #yiv0403279266ygrp-msg
p#yiv0403279266attach-count span {color:#1E66AE;font-weight:700;}#yiv0403279266
#yiv0403279266ygrp-reco #yiv0403279266reco-head
{color:#ff7900;font-weight:700;}#yiv0403279266 #yiv0403279266ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0403279266 #yiv0403279266ygrp-sponsor
#yiv0403279266ov li a {font-size:130%;text-decoration:none;}#yiv0403279266
#yiv0403279266ygrp-sponsor #yiv0403279266ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0403279266
#yiv0403279266ygrp-sponsor #yiv0403279266ov ul {margin:0;padding:0 0 0
8px;}#yiv0403279266 #yiv0403279266ygrp-text
{font-family:Georgia;}#yiv0403279266 #yiv0403279266ygrp-text p {margin:0 0 1em
0;}#yiv0403279266 #yiv0403279266ygrp-text tt {font-size:120%;}#yiv0403279266
#yiv0403279266ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0403279266 
Open_Sheet1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
