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 Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to create a snapdeal account
  • How to Install Classic Gnome menu in Ubuntu 14.04
  • How to Enable /Disable Virtual Keyboard in Windows 10?
  • How to Remove Startup Programs in Windows 7
  • How to merge PDF files

Copyright © 2023 · QueHow · Contact Us