Cara meng-aktifkan Excel Macro dan Enable Tab Developer

Halo sodara - sodara sebangsa tanah dan sebangsa air. kali ini saya akan membuat tutorial sederhana tentang excel. yaaa excel macro.. apasih excel macro?

Excel Macro atau yang sering juga disebut VBA(Visual Basic for Application) adalah sebuah bahasa pemograman sederhana yang nempel pada Microsoft Office(Excel, Word, Access, Power Point maupun Outlook) yang basic nya adalah Visual Basic. intinya sih itu kalo mau lebih lengkap tentang penjelesannya bisa dibaca aja disini >> https://en.wikipedia.org/wiki/Visual_Basic_for_Applications

Apa fungsinya? yang jelas fungsinya bagi pecinta coding dan automasi fitur ini sangat - sangat berguna dan mengasikan.. hahaha.. fitur ini jelas - jelas mempermudah pekerjaan yang dikerjakan sehari - hari nya.. yaaa memanusiakan manusia dan merobotkan robot lah.. hehehee..

Pokoknya  itu lah ya.. oke kita sekarang langsung aja untuk cara meng-aktifkannya. saya akan memberi contoh pada microsoft office excel 2010(untuk versi excel 2010 keatas cara setting nya sama, cuma di excel 2003 dan excel 2007 yang sedikit berbeda).

Pertama yang ada adalah komputer, trus pastikan komputer nya nyala, abis nyala pastikan ada microsoft excelnya (becannnndaaaaaaa.......).

  • Pertama buka excel jika kumpulan Tab(Home, Insert, Page Layout dll) tidak ada Tab Developer, bisa ikuti langkah - langkah berikut untuk menmunculkan. 
  • Klik [FILE] di pajok kiri atas.
  
  • Lalu pilih [OPTION].
 

  • Setelah muncul Form Excel Option, lalu pilih [Customize Ribbon].
 

  • Lalu Check / Centang Developer pada Main Tabs.
 

  • Klik Tombol [OK] dan berikut hasilnya.
 


Selanjutnya pastikan Macro Excel dalam keadaaan Enable. dengan cara:
  • Klik Tab Developer, dan klik Macro Security.


  • Masuk ke menu Macro Setting, Pilih Enable all macros(...) lalu OK
 

  • Selesai.

Selamat membuat aplikasi sederhana untuk mempermudah pekerjaan - pekerjaan kalian, untuk contoh akan saya tulis di tulisan saya berikutnya. saat ini beru cara mengaktifkannya aja ya.

Semoga Bermanfaat.. #HappyCoding #ExcelSakti








Comments

  1. oke bang di lanjut ya...postingannya di tunggu

    ReplyDelete
  2. https://www.bolagpsport.com/2018/02/daftar-link-live-streaming-siaran-bola.html


    Search engine optimization (SEO) or Indonesian SEO is the process of influencing the visibility of websites or web pages in search engine results - often referred to as "natural", "organic" or "earned" results. In general, the earlier (or rank higher on search results pages), and more often sites appear in the list of search results, the more visitors will receive from search engine users, and these visitors can be converted to customers.

    SEO can target various types of searches, including image search, local search, video search, academic search, news search and industry-specific vertical search engines.

    Indonesian SEO

    Specialist SEO.com is an Indonesian SEO Service launched in 2011 when search engines were in the early stages of developing their algorithms, Google was a big company that was very promising. Search engine optimization (SEO) has a completely different meaning. Since then many things have changed and internet marketing has become a necessity for every company that wants to survive in the online world competitively.

    Specialist SEO Indonesia SEO Services deal with Web Marketing technology from the start. After hours of research and development, trial and error, we can now offer the most reliable solutions in the world of Digital Marketing.

    Indonesian SEO Service

    You can chat, video call, phone, view photos, have fun, and even meet!
    online datingsite, online dating indonesia, free online dating, best online dating site free, online dating app, online dating terbaik, dating online chat, situs online dating, free dating sites without payment, dating online with video call, dating, meet me, meet, people nearby, soulmate, heart, online dating apps, free online dating, video call, audio chat, find your partner, setipe, skout, flurv, bigo live, Tinder, OkCupid, Hookup, BeeTalk
    online dating site

    pokerstar365.net is a card game that shares betting rules and is usually (but not always) in hand ranking. The Poker Online game is different in terms of how cards are shared. In the most modern Poker Games, the first round of betting starts with several forms. Type of card arrangement in Online Poker.

    poker online

    Choosing an online casino agent is essential if people want to work on online gambling. http://www.dompetcasino.org/ to make the play scene should really be done so that the smoothness in playing gambling can be enjoyed gambling agency sites online casino agency page can also be done with a system of observing recommendations and recommendations from more experienced players.
    judi online

    ReplyDelete
  3. Hanya 1 Id saja anda bisa bermain dan bersenang-senang dalam bermain di situs slot deposit dana BOS01

    https://172.104.59.107/

    ReplyDelete

Post a Comment