Sama2....Kalo sdh buat boleh dishare disini...biar temen2 yang lain bisa ikut
menikmati manfaatnya.
Salam,HK
From: "Tio Adi Bayu Adjie [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Friday, 15 January 2016, 17:16
Subject: RE: [belajar-excel] Disable right click di tab sheet dan menu bar
Oya, saya sudah mengerti. Terima kasih sekali lagi Pak Hendrik.
| | |
| | | |
| | | | |
From: [email protected] [mailto:[email protected]]
Sent: Friday, January 15, 2016 5:16 PM
To: [email protected]
Subject: Re: [belajar-excel] Disable right click di tab sheet dan menu bar
Seingat saya Codenya ditulis di Custom UI (hrs diinstal dulu) Coba ikuti
langkah2nya....maaf saya jarang main Custom UI, jadi sementara blm bisa jawab.
Salam, HK From: "Tio Adi Bayu [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Friday, 15 January 2016, 16:15
Subject: RE: [belajar-excel] Disable right click di tab sheet dan menu bar
Dear Pak Hendrik, Adakah langkah-langkah dalam penulisan custom UI part code ?
Dimana saya menulis code UI spt dibawah ini ? <customUI
xmlns="http://schemas.microsoft.com/office/2006/01/customui";> <ribbon
startFromScratch="false"> <tabs> <tab id="tabno1" label="Tabku"> </tab> </tabs>
</ribbon> </customUI> Terima kasih jawabannya.
| | |
| | | |
| | | | |
Regards, Tio From:[email protected]
[mailto:[email protected]]
Sent: Friday, January 15, 2016 2:35 PM
To: [email protected]
Subject: RE: [belajar-excel] Disable right click di tab sheet dan menu bar
| Pak Hendrik, kok tidak ada lampirannya yah ? Maaf. | |
| | | |
| | | | |
From:[email protected] [mailto:[email protected]]
Sent: Friday, January 15, 2016 2:25 PM
To: [email protected]
Subject: Re: [belajar-excel] Disable right click di tab sheet dan menu bar
Hai Tio, Coba lihat file/folder terlampir, 1. Ga bisa diklik kanan dan Cut,Copy
ga bisa diPaste 2. 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
| | |
| | | |
| | | | |
#yiv9942002698 #yiv9942002698 -- #yiv9942002698ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9942002698
#yiv9942002698ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9942002698
#yiv9942002698ygrp-mkp #yiv9942002698hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9942002698 #yiv9942002698ygrp-mkp #yiv9942002698ads
{margin-bottom:10px;}#yiv9942002698 #yiv9942002698ygrp-mkp .yiv9942002698ad
{padding:0 0;}#yiv9942002698 #yiv9942002698ygrp-mkp .yiv9942002698ad p
{margin:0;}#yiv9942002698 #yiv9942002698ygrp-mkp .yiv9942002698ad a
{color:#0000ff;text-decoration:none;}#yiv9942002698 #yiv9942002698ygrp-sponsor
#yiv9942002698ygrp-lc {font-family:Arial;}#yiv9942002698
#yiv9942002698ygrp-sponsor #yiv9942002698ygrp-lc #yiv9942002698hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9942002698
#yiv9942002698ygrp-sponsor #yiv9942002698ygrp-lc .yiv9942002698ad
{margin-bottom:10px;padding:0 0;}#yiv9942002698 #yiv9942002698actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9942002698
#yiv9942002698activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9942002698
#yiv9942002698activity span {font-weight:700;}#yiv9942002698
#yiv9942002698activity span:first-child
{text-transform:uppercase;}#yiv9942002698 #yiv9942002698activity span a
{color:#5085b6;text-decoration:none;}#yiv9942002698 #yiv9942002698activity span
span {color:#ff7900;}#yiv9942002698 #yiv9942002698activity span
.yiv9942002698underline {text-decoration:underline;}#yiv9942002698
.yiv9942002698attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9942002698 .yiv9942002698attach div a
{text-decoration:none;}#yiv9942002698 .yiv9942002698attach img
{border:none;padding-right:5px;}#yiv9942002698 .yiv9942002698attach label
{display:block;margin-bottom:5px;}#yiv9942002698 .yiv9942002698attach label a
{text-decoration:none;}#yiv9942002698 blockquote {margin:0 0 0
4px;}#yiv9942002698 .yiv9942002698bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9942002698
.yiv9942002698bold a {text-decoration:none;}#yiv9942002698 dd.yiv9942002698last
p a {font-family:Verdana;font-weight:700;}#yiv9942002698 dd.yiv9942002698last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9942002698
dd.yiv9942002698last p span.yiv9942002698yshortcuts
{margin-right:0;}#yiv9942002698 div.yiv9942002698attach-table div div a
{text-decoration:none;}#yiv9942002698 div.yiv9942002698attach-table
{width:400px;}#yiv9942002698 div.yiv9942002698file-title a, #yiv9942002698
div.yiv9942002698file-title a:active, #yiv9942002698
div.yiv9942002698file-title a:hover, #yiv9942002698 div.yiv9942002698file-title
a:visited {text-decoration:none;}#yiv9942002698 div.yiv9942002698photo-title a,
#yiv9942002698 div.yiv9942002698photo-title a:active, #yiv9942002698
div.yiv9942002698photo-title a:hover, #yiv9942002698
div.yiv9942002698photo-title a:visited {text-decoration:none;}#yiv9942002698
div#yiv9942002698ygrp-mlmsg #yiv9942002698ygrp-msg p a
span.yiv9942002698yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9942002698
.yiv9942002698green {color:#628c2a;}#yiv9942002698 .yiv9942002698MsoNormal
{margin:0 0 0 0;}#yiv9942002698 o {font-size:0;}#yiv9942002698
#yiv9942002698photos div {float:left;width:72px;}#yiv9942002698
#yiv9942002698photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9942002698
#yiv9942002698photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9942002698
#yiv9942002698reco-category {font-size:77%;}#yiv9942002698
#yiv9942002698reco-desc {font-size:77%;}#yiv9942002698 .yiv9942002698replbq
{margin:4px;}#yiv9942002698 #yiv9942002698ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9942002698 #yiv9942002698ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9942002698
#yiv9942002698ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9942002698
#yiv9942002698ygrp-mlmsg select, #yiv9942002698 input, #yiv9942002698 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9942002698
#yiv9942002698ygrp-mlmsg pre, #yiv9942002698 code {font:115%
monospace;}#yiv9942002698 #yiv9942002698ygrp-mlmsg *
{line-height:1.22em;}#yiv9942002698 #yiv9942002698ygrp-mlmsg #yiv9942002698logo
{padding-bottom:10px;}#yiv9942002698 #yiv9942002698ygrp-msg p a
{font-family:Verdana;}#yiv9942002698 #yiv9942002698ygrp-msg
p#yiv9942002698attach-count span {color:#1E66AE;font-weight:700;}#yiv9942002698
#yiv9942002698ygrp-reco #yiv9942002698reco-head
{color:#ff7900;font-weight:700;}#yiv9942002698 #yiv9942002698ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9942002698 #yiv9942002698ygrp-sponsor
#yiv9942002698ov li a {font-size:130%;text-decoration:none;}#yiv9942002698
#yiv9942002698ygrp-sponsor #yiv9942002698ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9942002698
#yiv9942002698ygrp-sponsor #yiv9942002698ov ul {margin:0;padding:0 0 0
8px;}#yiv9942002698 #yiv9942002698ygrp-text
{font-family:Georgia;}#yiv9942002698 #yiv9942002698ygrp-text p {margin:0 0 1em
0;}#yiv9942002698 #yiv9942002698ygrp-text tt {font-size:120%;}#yiv9942002698
#yiv9942002698ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9942002698
