Cara Menghapus Makro di Excel

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Artikel wikiHow ini akan mengajarkan kepada Anda cara menghapus makro dari lembar lajur Microsoft Excel. Anda bisa menghapus makro melalui pengaturan lembar di Excel pada komputer Windows dan Mac.

Metode 1
Metode 1 dari 2:

Pada Komputer Windows

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Remove-a-Macro-in-Excel-Step-1.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Remove-a-Macro-in-Excel-Step-1.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":259,"bigWidth":728,"bigHeight":410,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik dua kali berkas Excel dengan makro yang perlu dihapus. Setelah itu, berkas akan dibuka di Excel.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/96\/Remove-a-Macro-in-Excel-Step-2.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/96\/Remove-a-Macro-in-Excel-Step-2.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada bilah kuning di bagian atas jendela Excel. Makro yang tertanam dalam berkas akan diaktifkan setelahnya.
    • Jika makro tidak diaktifkan, Anda tidak bisa menghapusnya.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Remove-a-Macro-in-Excel-Step-3.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Remove-a-Macro-in-Excel-Step-3.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":262,"bigWidth":728,"bigHeight":414,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tab ini berada pada pita hijau di bagian atas jendela Excel.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d6\/Remove-a-Macro-in-Excel-Step-4.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d6\/Remove-a-Macro-in-Excel-Step-4.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ikon drop-down
    Android 7 Dropdown
    {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/8\/82\/Android7dropdown.png","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Android7dropdown.png\/30px-Android7dropdown.png","smallWidth":460,"smallHeight":460,"bigWidth":30,"bigHeight":30,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    ini berada di ujung kanan tab “ View ”. Menu drop-down akan ditampilkan setelahnya.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e5\/Remove-a-Macro-in-Excel-Step-5.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Remove-a-Macro-in-Excel-Step-5.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada menu drop-down . Setelah itu, jendela pop-up “ Macros ” akan ditampilkan.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a3\/Remove-a-Macro-in-Excel-Step-6.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Remove-a-Macro-in-Excel-Step-6.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":411,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Kotak ini berada di bagian bawah jendela. Setelah diklik, menu drop-down akan ditampilkan.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Remove-a-Macro-in-Excel-Step-7.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Remove-a-Macro-in-Excel-Step-7.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":259,"bigWidth":728,"bigHeight":410,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada menu drop-down .
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b9\/Remove-a-Macro-in-Excel-Step-8.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Remove-a-Macro-in-Excel-Step-8.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik nama makro yang perlu dihapus.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/13\/Remove-a-Macro-in-Excel-Step-9.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/13\/Remove-a-Macro-in-Excel-Step-9.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada di sisi kanan jendela.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Remove-a-Macro-in-Excel-Step-10.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Remove-a-Macro-in-Excel-Step-10.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":411,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Setelah itu, makro akan dihapus dari buku pekerjaan.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3e\/Remove-a-Macro-in-Excel-Step-11.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3e\/Remove-a-Macro-in-Excel-Step-11.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":259,"bigWidth":728,"bigHeight":410,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tekan tombol Ctrl + S untuk menyimpannya. Dengan demikian, makro akan tetap terhapus setelah Excel ditutup.
    Iklan
Metode 2
Metode 2 dari 2:

Pada Komputer Mac

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/42\/Remove-a-Macro-in-Excel-Step-12.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/42\/Remove-a-Macro-in-Excel-Step-12.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik dua kali berkas Excel dengan makro yang perlu dihapus. Setelah itu, berkas akan dibuka di Excel.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/46\/Remove-a-Macro-in-Excel-Step-13.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/46\/Remove-a-Macro-in-Excel-Step-13.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-13.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":411,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada bilah kuning di bagian atas jendela Excel. Makro yang tertanam dalam berkas akan diaktifkan setelahnya.
    • Jika makro tidak diaktifkan, Anda tidak bisa menghapusnya.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c3\/Remove-a-Macro-in-Excel-Step-14.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Remove-a-Macro-in-Excel-Step-14.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-14.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi menu ini berada di bagian atas layar komputer. Setelah diklik, menu drop-down akan ditampilkan.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/73\/Remove-a-Macro-in-Excel-Step-15.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/73\/Remove-a-Macro-in-Excel-Step-15.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-15.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada di bagian bawah menu drop-down “ Tools ”. Setelah dipilih, menu baru akan ditampilkan di sisi kanan menu drop-down .
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Remove-a-Macro-in-Excel-Step-16.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Remove-a-Macro-in-Excel-Step-16.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-16.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada menu pop-out . Setelah itu, jendela " Macros " akan dibuka. [1]
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/0d\/Remove-a-Macro-in-Excel-Step-17.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0d\/Remove-a-Macro-in-Excel-Step-17.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-17.jpg","smallWidth":460,"smallHeight":259,"bigWidth":728,"bigHeight":410,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Kotak ini berada di bagian bawah jendela " Macros ". Setelah itu, menu drop-down akan ditampilkan.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f0\/Remove-a-Macro-in-Excel-Step-18.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/Remove-a-Macro-in-Excel-Step-18.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-18.jpg","smallWidth":460,"smallHeight":259,"bigWidth":728,"bigHeight":410,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada menu drop-down .
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1e\/Remove-a-Macro-in-Excel-Step-19.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Remove-a-Macro-in-Excel-Step-19.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-19.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":411,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik nama makro yang perlu dihapus.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2f\/Remove-a-Macro-in-Excel-Step-20.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Remove-a-Macro-in-Excel-Step-20.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-20.jpg","smallWidth":460,"smallHeight":260,"bigWidth":728,"bigHeight":411,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tombol ini berada di bawah daftar makro.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2d\/Remove-a-Macro-in-Excel-Step-21.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2d\/Remove-a-Macro-in-Excel-Step-21.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-21.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Makro akan dihapus setelahnya.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/04\/Remove-a-Macro-in-Excel-Step-22.jpg\/v4-460px-Remove-a-Macro-in-Excel-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/04\/Remove-a-Macro-in-Excel-Step-22.jpg\/v4-728px-Remove-a-Macro-in-Excel-Step-22.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":409,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tekan tombol ⌘ Command + S untuk menyimpan dokumen. Dengan demikian, makro akan tetap terhapus setelah Excel ditutup.
    Iklan

Tips

  • Pada komputer Mac, Anda juga bisa membuka jendela " Macros " melalui tab “ Developer ” dengan mengeklik opsi “ Macros ”.
Iklan

Peringatan

  • Makro dapat membahayakan komputer. Jangan jalankan makro dari berkas yang tidak Anda buat sendiri, kecuali Anda mengetahui sumbernya (mis. makro dibuat oleh teman yang dapat dipercaya).
Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara Mudah Membuat Tanda Panah di Word pada Komputer Windows atau Mac
Iklan

Referensi

  1. ↑ https://support.office.com/en-us/article/create-run-edit-or-delete-a-macro-fc5fb55d-124d-4cc7-bae0-111c9c26e234

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 18.537 kali.

Apakah artikel ini membantu Anda?

Iklan