GENK IT

LOGO GROBOGAN

LOGO GROBOGAN

Amankan Konten Wordpressmu ..!!!

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 21.0pt; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGN86Xq9wTET9HHI3p_kokIw3NT9WyGJvjkTy20io043HDDBJRvYvTEXY98cOplxnI6veIGJlaZedcZWAmvMey4BruNrUOdL2t6xCCt8PfKXltdQ4LnEwvT1xXwknXiJEzADH6nl1L0kR/s1600/EXPORT+IMPORT.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="295" data-original-width="640" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGN86Xq9wTET9HHI3p_kokIw3NT9WyGJvjkTy20io043HDDBJRvYvTEXY98cOplxnI6veIGJlaZedcZWAmvMey4BruNrUOdL2t6xCCt8PfKXltdQ4LnEwvT1xXwknXiJEzADH6nl1L0kR/s400/EXPORT+IMPORT.JPG" width="400" /></a></div>
<span style="color: #333333; font-family: "open sans" , "sans-serif"; font-size: 13.0pt;">Pernah mengalami situs
Wordpress terjadi Error / rusak? Semua konten atau data-data anda hilang? Sekarang,
jangan lagi terjadi. Gimana caranya? <b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;">Manfaatkan fasilitas menu Tools Import dan
Export. </i></b>Simak<b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"> </i></b>ulasan cara mengoperasikan tools
tersebut agar kedepan hati anda tenang jika terjadi Wordpress Error / rusak.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 21.0pt; text-align: justify;">
<span style="color: #333333; font-family: "open sans" , "sans-serif"; font-size: 13.0pt;"><b><a href="https://lkpwapres.blogspot.com/2020/06/tutorial-import-eksport-konten-wordpress.html" target="_blank">KLIK DISINI</a> Tutorial Import dan Export Wordpress</b></span></div>
</div>

Amankan Konten Wordpressmu ..!!!

Pernah mengalami situs Wordpress terjadi Error / rusak? Semua konten atau data-data anda hilang? Sekarang, jangan lagi terjadi. Gimana ...

Tutorial Buat Judul Blog Berputar

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoeAZ-WwXj7dHNP3fWVC5YejqolnMp8UuwgK33Www0BoeL2oqMu7V45ZoNU2gX8iS1IANKS3l1Gqzjvk7wo3TjZYC7vIgowlky4AAKU2etNP_I8W5Lm1cY0LW7ujXPG-mvMGzZh2lh7J_0/s1600/blogger.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="512" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoeAZ-WwXj7dHNP3fWVC5YejqolnMp8UuwgK33Www0BoeL2oqMu7V45ZoNU2gX8iS1IANKS3l1Gqzjvk7wo3TjZYC7vIgowlky4AAKU2etNP_I8W5Lm1cY0LW7ujXPG-mvMGzZh2lh7J_0/s200/blogger.png" width="200" /></a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm; text-align: justify;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;"><b>Hello Genker's...</b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm; text-align: justify;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Mungkin sobat pernah melihat Blog yang Judulnya / Title </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Bergerak pada Address Bar? dan anda menginginkan Blog sobat seperti itu juga? Ingin tahu cara buatnya? berikut ulasan cara pembuatannya :</span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">1. Masuk ke <i>Dashboard</i>  Blogger<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">2. Masuk ke Blog yang akan dibuat<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">3. Masuk ke <i>Template</i> / Tema<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">4. Pilih Edit Html<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">5. Cari kode atau menggunakan <b>Ctrl + F</b><o:p></o:p></span></div>
<div style="background: white; border-color: rgb(225, 225, 225) rgb(240, 240, 240) rgb(225, 225, 225) rgb(231, 76, 60); border-style: solid; border-width: 1pt 1pt 1pt 1.5pt; margin-left: 21.3pt; margin-right: 0cm; padding: 6pt 6pt 6pt 0cm;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><title><data:blog.pageTitle/></title> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">atau </span><span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><title><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">6. Kemudian hapus Kode tersebut</span><span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">7. Di area yang dihapus tadi , Copas Kode berikut :<o:p></o:p></span></div>
<div style="background: white; border-color: rgb(225, 225, 225) rgb(240, 240, 240) rgb(225, 225, 225) rgb(231, 76, 60); border-style: solid; border-width: 1pt 1pt 1pt 1.5pt; margin-left: 21.3pt; margin-right: 0cm; padding: 6pt 6pt 6pt 0cm;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="font-family: "bahnschrift" , sans-serif;"><</span></i><i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">script language='JavaScript'><o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">var txt=" </span></i><i><span style="color: red; font-family: "bahnschrift" , sans-serif;">GARUDA PURI > CERDAS | CERIA | BERPRESTASI</span></i><i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> ";<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">var kecepatan=120;var segarkan=null;function bergerak() { document.title=txt;<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">txt=txt.substring(1,txt.length)+txt.charAt(0);<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">segarkan=setTimeout("bergerak()",kecepatan);}bergerak();<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"></script><o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">8. Ganti Teks </span><span style="color: red; font-family: "bahnschrift" , sans-serif;">Warna Merah</span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> sesuai judul blog anda<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">9. Klik <b>Simpan </b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">10. Selesai...... </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Tralalaaaaaaaa…</span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Jadi dech..!!!!</span><br />
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;"><br /></span>
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">LIHAT CONTOH HASILNYA DI BLOG : </span><a href="https://garudapuri.blogspot.com/" target="_blank"><span style="font-family: "trebuchet ms" , sans-serif;"><b>https://garudapuri.blogspot.com/</b></span></a></div>

Tutorial Buat Judul Blog Berputar

Hello Genker's... Mungkin sobat pernah melihat Blog yang Judulnya / Title Bergerak pada Address Bar? dan anda menginginkan Blog ...

Visual Basic Aplication

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Hn-VNzNh0X-Pe9P6A7XCp_7RJTNbc6wEjq59Av1wgvVQX793IGKIsfVvpN9hc9JdqkMbH31Mn-1rarozutMuANfNtFtWph0HiSBe9qaz9fdHxjSU9TIs2ABU68ELR18avnVkbVAHgwgE/s1600/VBA+EXCEL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="362" data-original-width="548" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Hn-VNzNh0X-Pe9P6A7XCp_7RJTNbc6wEjq59Av1wgvVQX793IGKIsfVvpN9hc9JdqkMbH31Mn-1rarozutMuANfNtFtWph0HiSBe9qaz9fdHxjSU9TIs2ABU68ELR18avnVkbVAHgwgE/s320/VBA+EXCEL.jpg" width="320" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<ol style="text-align: left;">
<li><a href="https://genkcomp.blogspot.com/2019/09/membuat-link-internet-pada-vba-excel.html" target=""><span style="font-family: Verdana, sans-serif;">Membuat Link URl di UserForm Microsoft Excel</span></a></li>
<li><a href="https://genkcomp.blogspot.com/2019/09/cara-membuat-menu-ribbon-sendiri-di.html"><span style="font-family: Verdana, sans-serif;">Memodifikasi Menu Ribbon Sendiri di Microsoft Excel</span></a></li>
<li><a href="https://genkcomp.blogspot.com/2019/09/membuat-teks-berjalan-pada-vba-excel.html"><span style="font-family: Verdana, sans-serif;">Membuat Teks Berjalan di UserForm</span></a></li>
</ol>
</div>

Visual Basic Aplication

Membuat Link URl di UserForm Microsoft Excel Memodifikasi Menu Ribbon Sendiri di Microsoft Excel Membuat Teks Berjalan di UserForm

Membuat Link URL di VBA Microsoft Excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">Sobat Genk IT, disini kami sampaikan pembuatan link URL pada label pada userform di Aplikasi berbasis VBA Microsoft Excel, sehingga ketika di klik pada label tersebut akan langsung menuju ke
sebuah halaman web yang diatur. </span><br />
<span style="font-family: "arial" , sans-serif;"><br /></span>
<span style="font-family: "arial" , sans-serif;">Berikut ulasan pembuatan link URL pada label di userform :</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif;">1. Masuk ke <b>Microsoft Visual Basic Excel </b>(tekan Alt+F11),</span><br />
<span style="font-family: "arial" , sans-serif;">2. Klik kanan <b>VBAProject </b><i><b>(file anda) > </b>Klik <b>Insert > </b>Pilih <b>UserForm</b></i></span><br />
<span style="font-family: "arial" , sans-serif;">3. Pada halaman <b>UserForm</b>, buatlah label dari <i>Toolbox</i></span><br />
<span style="font-family: "arial" , sans-serif;">4. Selanjutnya Klik Label tersebut, kemudian lakukan pengaturan Label di Properties </span><br />
<span style="font-family: "arial" , sans-serif;">    sebagaimana gambar berikut :</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5xCX1T__YI0cOhwafzEXkj16eYyYqZ8DKrmoBDcejJ9kuWewGRxfMyGNXdn7MsSaingT16a6nDadnJaWMeGHLfKfV8rUZ-8gc77YeNuNuOeFdLm7tN8goucOa4xuLFNwcMhrpeZleH0H-/s1600/VBA+LINK.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="557" data-original-width="800" height="443" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5xCX1T__YI0cOhwafzEXkj16eYyYqZ8DKrmoBDcejJ9kuWewGRxfMyGNXdn7MsSaingT16a6nDadnJaWMeGHLfKfV8rUZ-8gc77YeNuNuOeFdLm7tN8goucOa4xuLFNwcMhrpeZleH0H-/s640/VBA+LINK.JPG" width="640" /></a></div>
<span style="font-family: "arial" , sans-serif;"><br /></span>
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">5. Double Klik Label tersebut,  kemudian </span><span style="font-family: "arial" , sans-serif; font-size: 12pt;">Ketik Kode dibawah ini  :</span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">6. </span><span style="font-family: "arial" , sans-serif; font-size: 16px;">Simpan / Save (Ctrl+S)</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span>
<span style="color: blue; font-family: "arial" , sans-serif;">Private Sub Label1_Click()</span><br />
<span style="font-family: "arial" , sans-serif;"><span style="color: blue;">ActiveWorkbook.FollowHyperlink "</span><b><span style="color: red;">https://genkcomp.blogspot.com/</span></b><span style="color: blue;">"</span></span><br />
<span style="color: blue; font-family: "arial" , sans-serif;">End Sub</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span>
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><i><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">Kode diatas berfungsi dengan baik (telah dicoba) ketika sebuah komputer yang terhubung dengan jaringan internet, jika ketika komputer dalam keadaan off-line , maka sebuah pesan error akan ditampilkan. </span></i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><i><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">Ganti alamat URL (yang berwarna </span><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 12pt; line-height: 24px;">merah</span><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">) tersebut dengan alamat URL yang diinginkan.</span></i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;"><br /></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">7. Tekan Tobol F5 untuk menjalankan / mencoba</span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">8. Simpan File Excel Tipe <i>Excel Macro-Enabled Worksheet (.xlsm)</i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><i><br /></i></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 24px; margin-bottom: 0cm;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">Contoh Label Link URL pada UserForm Login, yang kami buat untuk aplikasi VBA <b>SIAP-Desa </b><i>(sebuah aplikasi berbasis VBA Excel untuk Otomasi Pembuatan Administrasi Pengadaan Barang dan Jasa TPK Desa), silahkan unduh di </i><b><a href="https://desapanunggalan.blogspot.com/2020/06/link-download2.html" target="_blank">SIAP-DESA</a></b></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><b>Kunci : kerjacerdas</b></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><b>Pengguna : siap</b></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 24px; margin: 0cm 0cm 0cm 18pt;">
</div>
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span>
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span></div>
</div>

Membuat Link URL di VBA Microsoft Excel

Sobat Genk IT, disini kami sampaikan pembuatan link URL pada label pada userform di Aplikasi berbasis VBA Microsoft Excel, sehingga ketik...

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; text-align: justify; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div align="center" class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 12.0pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s1600/RIBBON+EXCEL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black;"><img border="0" data-original-height="328" data-original-width="640" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s320/RIBBON+EXCEL.jpg" width="320" /></span></a></div>
<br />
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat Genk IT....</b></span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b><br /></b></span>
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat pernah menggunakan aplikasi berbasis VBA Microsoft Excel? aplikasi tersebut telah memodifikasi menu ribbon Microsoft Excel? Kok Bisa? Gimana Cara membuat Menu Ribbon Di Excel tersebut? </b></span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Memodifikasi ribbon menu di Microsoft Excel sebenarnya sangat mdah, hanya  membutuhkan tool-tool atau software tambahan tertentu dan ketekunan dan semangat untuk belajar </span><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">saja.</span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<b><span style="border: none 1.0pt; font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt; padding: 0cm;">Langkah-langkah
memodifikasi menu ribbon Microsoft Excel</span></b></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Sebelum mengunduh software Custom UI Editor, silahkan membuat
file excel yang bisa digunakan untuk menyisipkan kode macro biasanya type (excel
macro) atau extensinya .xlsm</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1.</span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> <span style="color: black;">Download </span><span style="color: blue;"><b><a href="https://desapanunggalan.blogspot.com/2020/06/link-download-ribbon-editor.html" target="_blank">OfficeCustomUIEditorSetup</a></b></span></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> (size
228 kb)</span></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">Software ini freeware alias Gratis... tenang saja sob....</span></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">2.
Setelah terunduh, buka Software tersebut dengan aplikasi <b>Winrar</b></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">3. Buka
software, kemuadian double klik </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;"><b>OfficeCustomUIEditorSetup.msi </b> untuk instalasi</span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<b><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Mengoperasikan </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Office CustomUI Editor</span></b><br />
 <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1.
Aktifkan Software tersebut, kemudian buka aplikasi yang akan di modif di menu </span><b style="font-family: "trebuchet ms", sans-serif; font-size: 10.5pt;">File > Open</b><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> </span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">    atau klik icon Open</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s1600/MODIF+RIBBON.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="543" data-original-width="800" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s320/MODIF+RIBBON.JPG" width="320" /></a></div>
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">2. Buka File Excel yang dimodifikasi (jika tidak tampil, pilih kategori <b>All Files) <i>buat latihan, silahkan</i></b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><b><i><span style="font-size: 10.5pt;">   unduh File SIAP Desa </span><a href="https://desapanunggalan.blogspot.com/2020/06/link-download2.html" target="_blank">DISINI</a></i></b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">3. Akan tampil sebagai berikut (Ribbon telah dimodif), coba lakukan latihan dengan menampilkan NEW,</span><br />
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">    caranya di script </span><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;"><button idMso="FileNew" visible="<b>false</b>"/> , falase rubahlah <b>true.</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s1600/MODIF+RIBBON+-+Copy+%25282%2529.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="555" data-original-width="800" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s320/MODIF+RIBBON+-+Copy+%25282%2529.JPG" width="320" /></a></div>
<div class="MsoNormal" style="line-height: 17pt; margin-bottom: 0cm;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">4. Selanjutnya untuk mengecek klik menu <b style="mso-bidi-font-weight: normal;">validate</b></span><span style="font-family: "times new roman" , "serif"; font-size: 12pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">5. Apabila sudah oke maka silahkan klik <b>simpan </b></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">6. Selanjutnya Klik <b>File  > </b></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><b>Close</b></span></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">8. Kemudian Bukalah file exel tersebut, <b>tralalaaaaaaaa LIHATLAH PERUBAHANNYA...</b></span></span><br />
<div>
<br /></div>
<div>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Silahkan mencoba, semoga bermanfaat</span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; vertical-align: baseline;">
<br /></div>
</div>
</div>

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

Sobat Genk IT.... Sobat pernah menggunakan aplikasi berbasis VBA Microsoft Excel? aplikasi tersebut telah memodifikasi menu ri...