Hai Tio,Coba lihat file/folder terlampir,1. Ga bisa diklik kanan dan Cut,Copy
ga bisa diPaste2. Folder Ribbon Change yang berisi link untuk membuat menu
sendiri serta contoh2nya.
Ini saya dapat dari milis dan internet.
Salam, HK
From: "Tio Adi Bayu Adjie [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Friday, 15 January 2016, 9:26
Subject: [belajar-excel] Disable right click di tab sheet dan menu bar
Salam Excel Expert, Saya mau bertanya : 1. Bagaimana code vba untuk
disable right click di tab sheet ? 2. Adakah code vba untuk menon-aktifkan
menu bar dan command bar di excel hanya di 1 workbook yang dituju ? dan
memunculkan dengan menu sendiri ? Saya sudah cari di google, tapi tidak
berhasil-berhasil juga. Terima kasih bantuannya. Semoga Tuhan YME
membalasnya. Amiin. Salam, Tio
| | |
| | | |
| | | | |
#yiv0387691429 #yiv0387691429 -- #yiv0387691429ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0387691429
#yiv0387691429ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0387691429
#yiv0387691429ygrp-mkp #yiv0387691429hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0387691429 #yiv0387691429ygrp-mkp #yiv0387691429ads
{margin-bottom:10px;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad
{padding:0 0;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad p
{margin:0;}#yiv0387691429 #yiv0387691429ygrp-mkp .yiv0387691429ad a
{color:#0000ff;text-decoration:none;}#yiv0387691429 #yiv0387691429ygrp-sponsor
#yiv0387691429ygrp-lc {font-family:Arial;}#yiv0387691429
#yiv0387691429ygrp-sponsor #yiv0387691429ygrp-lc #yiv0387691429hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0387691429
#yiv0387691429ygrp-sponsor #yiv0387691429ygrp-lc .yiv0387691429ad
{margin-bottom:10px;padding:0 0;}#yiv0387691429 #yiv0387691429actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0387691429
#yiv0387691429activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0387691429
#yiv0387691429activity span {font-weight:700;}#yiv0387691429
#yiv0387691429activity span:first-child
{text-transform:uppercase;}#yiv0387691429 #yiv0387691429activity span a
{color:#5085b6;text-decoration:none;}#yiv0387691429 #yiv0387691429activity span
span {color:#ff7900;}#yiv0387691429 #yiv0387691429activity span
.yiv0387691429underline {text-decoration:underline;}#yiv0387691429
.yiv0387691429attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0387691429 .yiv0387691429attach div a
{text-decoration:none;}#yiv0387691429 .yiv0387691429attach img
{border:none;padding-right:5px;}#yiv0387691429 .yiv0387691429attach label
{display:block;margin-bottom:5px;}#yiv0387691429 .yiv0387691429attach label a
{text-decoration:none;}#yiv0387691429 blockquote {margin:0 0 0
4px;}#yiv0387691429 .yiv0387691429bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0387691429
.yiv0387691429bold a {text-decoration:none;}#yiv0387691429 dd.yiv0387691429last
p a {font-family:Verdana;font-weight:700;}#yiv0387691429 dd.yiv0387691429last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0387691429
dd.yiv0387691429last p span.yiv0387691429yshortcuts
{margin-right:0;}#yiv0387691429 div.yiv0387691429attach-table div div a
{text-decoration:none;}#yiv0387691429 div.yiv0387691429attach-table
{width:400px;}#yiv0387691429 div.yiv0387691429file-title a, #yiv0387691429
div.yiv0387691429file-title a:active, #yiv0387691429
div.yiv0387691429file-title a:hover, #yiv0387691429 div.yiv0387691429file-title
a:visited {text-decoration:none;}#yiv0387691429 div.yiv0387691429photo-title a,
#yiv0387691429 div.yiv0387691429photo-title a:active, #yiv0387691429
div.yiv0387691429photo-title a:hover, #yiv0387691429
div.yiv0387691429photo-title a:visited {text-decoration:none;}#yiv0387691429
div#yiv0387691429ygrp-mlmsg #yiv0387691429ygrp-msg p a
span.yiv0387691429yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0387691429
.yiv0387691429green {color:#628c2a;}#yiv0387691429 .yiv0387691429MsoNormal
{margin:0 0 0 0;}#yiv0387691429 o {font-size:0;}#yiv0387691429
#yiv0387691429photos div {float:left;width:72px;}#yiv0387691429
#yiv0387691429photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0387691429
#yiv0387691429photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0387691429
#yiv0387691429reco-category {font-size:77%;}#yiv0387691429
#yiv0387691429reco-desc {font-size:77%;}#yiv0387691429 .yiv0387691429replbq
{margin:4px;}#yiv0387691429 #yiv0387691429ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0387691429 #yiv0387691429ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0387691429
#yiv0387691429ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0387691429
#yiv0387691429ygrp-mlmsg select, #yiv0387691429 input, #yiv0387691429 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0387691429
#yiv0387691429ygrp-mlmsg pre, #yiv0387691429 code {font:115%
monospace;}#yiv0387691429 #yiv0387691429ygrp-mlmsg *
{line-height:1.22em;}#yiv0387691429 #yiv0387691429ygrp-mlmsg #yiv0387691429logo
{padding-bottom:10px;}#yiv0387691429 #yiv0387691429ygrp-msg p a
{font-family:Verdana;}#yiv0387691429 #yiv0387691429ygrp-msg
p#yiv0387691429attach-count span {color:#1E66AE;font-weight:700;}#yiv0387691429
#yiv0387691429ygrp-reco #yiv0387691429reco-head
{color:#ff7900;font-weight:700;}#yiv0387691429 #yiv0387691429ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0387691429 #yiv0387691429ygrp-sponsor
#yiv0387691429ov li a {font-size:130%;text-decoration:none;}#yiv0387691429
#yiv0387691429ygrp-sponsor #yiv0387691429ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0387691429
#yiv0387691429ygrp-sponsor #yiv0387691429ov ul {margin:0;padding:0 0 0
8px;}#yiv0387691429 #yiv0387691429ygrp-text
{font-family:Georgia;}#yiv0387691429 #yiv0387691429ygrp-text p {margin:0 0 1em
0;}#yiv0387691429 #yiv0387691429ygrp-text tt {font-size:120%;}#yiv0387691429
#yiv0387691429ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0387691429
