Cara Menulis Makro Sederhana di Microsoft Excel

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Artikel wikiHow ini menjelaskan cara membuat makro sederhana untuk lembar sebar ( spreadsheet ) Excel.

Bagian 1
Bagian 1 dari 3:

Mengaktifkan Makro

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b5\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Anda bisa melakukan proses yang sama untuk mengaktifkan makro pada Excel 2010, 2013, dan 2016. Terdapat sedikit perbedaan pada Excel untuk Mac, yang akan dijelaskan di bagian bawah.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b3\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b3\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Pada Mac, klik menu " Excel ".
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/be\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/be\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Pada Mac, klik opsi " Preferences ".
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b9\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Pada Mac, klik " Ribbon & Toolbar " di bagian " Authoring ".
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f1\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Pada Mac, Anda bisa menemukan " Developer " di daftar " Tab or Group Title ".
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/02\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tab Developer akan ditampilkan di bagian terakhir daftar tab .
    Iklan
Bagian 2
Bagian 2 dari 3:

Merekam Makro

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b6\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b6\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ketika merekam makro, apa saja yang diklik atau dilakukan akan direkam. Jadi, satu kesalahan bisa merusak semua hal. Lakukan latihan menjalankan perintah perekaman beberapa kali agar Anda bisa melakukannya tanpa ragu dan tidak salah mengeklik.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c8\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/92\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/92\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada di bagian Code di dalam pita ( ribbon ) Excel. Anda juga bisa memulai makro baru dengan menekan tombol Alt + T + M + R (hanya untuk Windows).
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/96\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/96\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Gunakan nama yang mudah dikenali, terutama apabila Anda ingin membuat beberapa makro.
    • Anda juga bisa memberi deskripsi untuk menjelaskan fungsi makro tersebut.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/16\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Anda bisa membuat pintasan kibor ( keyboard shortcut ) agar makro tersebut bisa dijalankan dengan mudah. Namun, ini opsional.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/14\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/14\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sebuah kombinasi kibor berupa Ctrl + ⇧ Shift +huruf akan dibuat untuk menjalankan makro tersebut.
    • Pada komputer Mac, kombinasi kibornya adalah ⌥ Opt + ⌘ Command +huruf.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3e\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3e\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jika makro tersebut hanya digunakan untuk lembar sebar pada saat ini, biarkan lokasinya tetap di " This Workbook ". Jika makro ingin digunakan untuk semua lembar sebar yang Anda kerjakan, pilih " Personal Macro Workbook ".
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Makro tersebut akan mulai merekam.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Apa saja yang Anda lakukan pada saat ini akan direkam dan ditambahkan ke dalam makro. Sebagai contoh, apabila Anda menjalankan rumus penjumlahan A2 dan B2 di sel C7, Excel akan menjumlahkan A2 dan B2, kemudian menampilkan hasilnya di C7 ketika Anda menjalankan makro tersebut di masa datang.
    • Makro dapat menjadi hal yang sangat kompleks, dan bahkan Anda juga bisa menggunakannya untuk menjalankan program Office yang lain. Saat makro merekam, hampir segala hal yang dilakukan pada Excel akan ditambahkan ke dalam makro.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7b\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7b\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Perekaman makro akan diakhiri dan hasilnya akan disimpan.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/66\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/66\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Agar makro tetap dipertahankan, Anda harus menyimpan buku kerja ( workbook ) dalam format Excel yang telah mengaktifkan makro:
    • Pilih menu File , kemudian klik Save .
    • Klik menu File Type di bawah kolom nama berkas.
    • Klik Excel Macro-Enabled Workbook .
    Iklan
Bagian 3
Bagian 3 dari 3:

Menggunakan Makro

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2c\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Apabila Anda telah menutup berkas sebelum menjalankan makro, Anda akan diminta untuk mengaktifkan konten.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini akan muncul di bagian atas lembar sebar Excel di bilah Security Warning setiap kali ada buku kerja yang telah mengaktifkan makro dibuka. Karena ini merupakan berkas milik Anda sendiri, tentu saja Anda bisa memercayainya. Namun, berhati-hatilah ketika membuka berkas yang telah mengaktifkan makro milik orang lain.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/ce\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/ce\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jika ingin menggunakan makro, Anda bisa menjalankannya secara cepat dengan menekan pintasan yang telah Anda buat.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c6\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Seluruh makro yang tersedia di dalam lembar sebar Anda pada saat ini akan ditampilkan.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f4\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f4\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/45\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/45\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Makro tersebut akan dijalankan di sel atau pilihan Anda pada saat ini.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d1\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg\/v4-460px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg\/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Apabila Anda ingin mengetahui cara kerja pengodean makro secara lebih terperinci, bukalah kode makro yang Anda buat dan otak-atik isinya:
    • Klik tombol Macros yang terdapat di tab Developer .
    • Klik makro yang ingin dilihat.
    • Klik Edit .
    • Lihatlah kode makro tersebut di program penyunting kode Visual Basic.
    Iklan


wikiHow Terkait

Cara Setting Equalizer Terbaik untuk Bass
Cara
Memeriksa Riwayat Penelusuran Web Menggunakan Router WiFi
Cara
Membaca Multimeter
Cara
Membuat Berkas Zip
Cara
Memperbaiki Print Spooler
Cara
Melakukan Reset pada PS3
Cara
Mencari Foto Seseorang
Cara
Mengukur Laptop
Cara
Berpura pura Meretas
Cara
Menggunakan Equalizer Grafis
Cara
Mengurutkan Data secara Alfabetis di Google Docs
Cara
Mengukur Televisi
Cara
Memasukkan Data di SPSS
Cara
Mendeteksi Kamera dan Mikrofon Tersembunyi
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 25.250 kali.

Apakah artikel ini membantu Anda?

Iklan