QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Delete Macro in MS Excel 2016?

By Neha T 1 Comment

Macro is an action or group of actions that is recorded, and it can be played back again as many times as required. The actions in macro can be a keystroke, mouse movements, typing text, or modifying text. In this article, we will discuss How to Delete Macro in MS Excel 2016? If you want to delete a macro that belongs to Personal Macro Workbook. Then you need to first unhide the workbook to delete that macro.

Steps to Delete Macro in MS Excel 2016:

Step 1: Open an Excel worksheet from which you want to delete macros. Go to the View tab in the ribbon. Under Macros group you have a Macros drop down button. Click the drop down arrow.

how-to-delete-macro-in-ms-excel-2016-step-1Step 2: When you click Macros, it provide three options:

View Macros: It shows you the list of the already created macro if any.
Record Macros: Selecting this option allows you to create your own macro that you can play back again.
Use Relative References: Selecting this will record the macros with the actions relative to the initially selected cell.

how-to-delete-macro-in-ms-excel-2016-step-2As now I need to view the list of macros. So that I can decide which macro to delete. Hence, I chose View Macros.

Step 3: A Macro dialog box is opened. Under Macro name: it shows the list of all the created macros. Now, here I want to delete the macro Highlight. So I will select Highlight from the list. Now you have to decide whether you want to remove the macro from All Open Workbooks or only fromĀ  This Workbook. I selected from This Workbook as I want to remove this from this workbook only. Click on Delete.

how-to-delete-macro-in-ms-excel-2016-step-3Step 4: A Microsoft Excel dialog box is opened. It confirms whether you want to delete the Highlight macro or not. To confirm click Yes.

how-to-delete-macro-in-ms-excel-2016-step-4

Thank you. Hope the content is useful. Keep reading

You Might Also Like:

how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? enable macro featured imageHow to Enable Macros in Excel 2016? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016? delete blank row feature imageHow to Delete Blank Rows in Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016?

Comments

  1. Amber says

    February 21, 2021 at 2:22 am

    Wow, that’s what I was looking for, what a data! existing here
    at this blog, thanks admin of this site.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Hide Active Status in Instagram?
  • How to Download and Save Instagram Stories?
  • How to Deactivate Account in Instagram?
  • How to Download Private Instagram Stories?
  • How to Slow Motion a Video in PowerDirector?
  • How to Check Who Unfollow You On Instagram?
  • How to Use Boomerang on Instagram?
  • How to Edit Video in PowerDirector?
  • How to Mute Someone’s Stories or Posts on Instagram?
  • How to Hide and Unhide Posts on Instagram?

Related Searches

  • How to Change the Date Format in Excel?
  • How to enable and disable Cookies in Mozilla fire firefox?
  • How to Slow Motion a Video in PowerDirector?
  • How to extract images from pdf file in Ubuntu 14.04
  • How to Use Boomerang on Instagram?

Copyright © 2021 · QueHow · Contact Us