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 Adjie [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 [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
| | |
| | | |
| | | | |
#yiv9281823652 #yiv9281823652 -- #yiv9281823652ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9281823652
#yiv9281823652ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9281823652
#yiv9281823652ygrp-mkp #yiv9281823652hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9281823652 #yiv9281823652ygrp-mkp #yiv9281823652ads
{margin-bottom:10px;}#yiv9281823652 #yiv9281823652ygrp-mkp .yiv9281823652ad
{padding:0 0;}#yiv9281823652 #yiv9281823652ygrp-mkp .yiv9281823652ad p
{margin:0;}#yiv9281823652 #yiv9281823652ygrp-mkp .yiv9281823652ad a
{color:#0000ff;text-decoration:none;}#yiv9281823652 #yiv9281823652ygrp-sponsor
#yiv9281823652ygrp-lc {font-family:Arial;}#yiv9281823652
#yiv9281823652ygrp-sponsor #yiv9281823652ygrp-lc #yiv9281823652hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9281823652
#yiv9281823652ygrp-sponsor #yiv9281823652ygrp-lc .yiv9281823652ad
{margin-bottom:10px;padding:0 0;}#yiv9281823652 #yiv9281823652actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9281823652
#yiv9281823652activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9281823652
#yiv9281823652activity span {font-weight:700;}#yiv9281823652
#yiv9281823652activity span:first-child
{text-transform:uppercase;}#yiv9281823652 #yiv9281823652activity span a
{color:#5085b6;text-decoration:none;}#yiv9281823652 #yiv9281823652activity span
span {color:#ff7900;}#yiv9281823652 #yiv9281823652activity span
.yiv9281823652underline {text-decoration:underline;}#yiv9281823652
.yiv9281823652attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9281823652 .yiv9281823652attach div a
{text-decoration:none;}#yiv9281823652 .yiv9281823652attach img
{border:none;padding-right:5px;}#yiv9281823652 .yiv9281823652attach label
{display:block;margin-bottom:5px;}#yiv9281823652 .yiv9281823652attach label a
{text-decoration:none;}#yiv9281823652 blockquote {margin:0 0 0
4px;}#yiv9281823652 .yiv9281823652bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9281823652
.yiv9281823652bold a {text-decoration:none;}#yiv9281823652 dd.yiv9281823652last
p a {font-family:Verdana;font-weight:700;}#yiv9281823652 dd.yiv9281823652last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9281823652
dd.yiv9281823652last p span.yiv9281823652yshortcuts
{margin-right:0;}#yiv9281823652 div.yiv9281823652attach-table div div a
{text-decoration:none;}#yiv9281823652 div.yiv9281823652attach-table
{width:400px;}#yiv9281823652 div.yiv9281823652file-title a, #yiv9281823652
div.yiv9281823652file-title a:active, #yiv9281823652
div.yiv9281823652file-title a:hover, #yiv9281823652 div.yiv9281823652file-title
a:visited {text-decoration:none;}#yiv9281823652 div.yiv9281823652photo-title a,
#yiv9281823652 div.yiv9281823652photo-title a:active, #yiv9281823652
div.yiv9281823652photo-title a:hover, #yiv9281823652
div.yiv9281823652photo-title a:visited {text-decoration:none;}#yiv9281823652
div#yiv9281823652ygrp-mlmsg #yiv9281823652ygrp-msg p a
span.yiv9281823652yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9281823652
.yiv9281823652green {color:#628c2a;}#yiv9281823652 .yiv9281823652MsoNormal
{margin:0 0 0 0;}#yiv9281823652 o {font-size:0;}#yiv9281823652
#yiv9281823652photos div {float:left;width:72px;}#yiv9281823652
#yiv9281823652photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9281823652
#yiv9281823652photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9281823652
#yiv9281823652reco-category {font-size:77%;}#yiv9281823652
#yiv9281823652reco-desc {font-size:77%;}#yiv9281823652 .yiv9281823652replbq
{margin:4px;}#yiv9281823652 #yiv9281823652ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9281823652 #yiv9281823652ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9281823652
#yiv9281823652ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9281823652
#yiv9281823652ygrp-mlmsg select, #yiv9281823652 input, #yiv9281823652 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9281823652
#yiv9281823652ygrp-mlmsg pre, #yiv9281823652 code {font:115%
monospace;}#yiv9281823652 #yiv9281823652ygrp-mlmsg *
{line-height:1.22em;}#yiv9281823652 #yiv9281823652ygrp-mlmsg #yiv9281823652logo
{padding-bottom:10px;}#yiv9281823652 #yiv9281823652ygrp-msg p a
{font-family:Verdana;}#yiv9281823652 #yiv9281823652ygrp-msg
p#yiv9281823652attach-count span {color:#1E66AE;font-weight:700;}#yiv9281823652
#yiv9281823652ygrp-reco #yiv9281823652reco-head
{color:#ff7900;font-weight:700;}#yiv9281823652 #yiv9281823652ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9281823652 #yiv9281823652ygrp-sponsor
#yiv9281823652ov li a {font-size:130%;text-decoration:none;}#yiv9281823652
#yiv9281823652ygrp-sponsor #yiv9281823652ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9281823652
#yiv9281823652ygrp-sponsor #yiv9281823652ov ul {margin:0;padding:0 0 0
8px;}#yiv9281823652 #yiv9281823652ygrp-text
{font-family:Georgia;}#yiv9281823652 #yiv9281823652ygrp-text p {margin:0 0 1em
0;}#yiv9281823652 #yiv9281823652ygrp-text tt {font-size:120%;}#yiv9281823652
#yiv9281823652ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9281823652
