How To Remove Last Modified By In Excel

Download Article

Download Commodity

This wikiHow teaches you how to remove a macro from a Microsoft Excel spreadsheet. You can practice this from within the spreadsheet'southward settings in Excel on both Windows and Mac computers.

1. 1

   Open up the macro-enabled Excel sheet. Double-click the Excel file which contains the macro you lot want to delete. This will open the file in Excel.

2. 2

   Click Enable Content . It'due south in the yellow bar at the elevation of the Excel window. This will enable the macro(s) that are embedded in the file.

   • If you don't enable the macro(s), you won't be able to delete your macro.

   Advertising

3. 3

   Click the View tab. This tab is in the greenish ribbon at the top of the Excel window.

4. 4

   Click Macros . It'southward a driblet-down icon

   in the far-right side of the View tab. A driblet-down card will appear.

5. 5

   Click View Macros . This option is in the drop-downward bill of fare. Doing then opens the Macros pop-up window.

6. 6

   Click the "Macros in" drib-down box. You lot'll discover this at the bottom of the window. Clicking it prompts a drib-downward menu.

7. seven

   Click All Open Workbooks . It's in the drop-down menu.

8. eight

   Select a macro. Click the proper noun of the macro yous desire to delete.

9. 9

   Click Delete . It'southward on the right side of the window.

10. 10

    Click Yes when prompted. Doing and then will remove the macro from your workbook.

11. eleven

    Save your changes. Press Ctrl+S to practice so. This will ensure that the macro remains deleted later you close Excel.

    Advertisement

1. ane

   Open the macro-enabled Excel canvas. Double-click the Excel file which contains the macro yous want to delete. This will open the file in Excel.

2. 2

   Click Enable Content . It's in the xanthous bar at the top of the Excel window. This will enable the macro(s) that are embedded in the file.

   • If you don't enable the macro(s), you won't exist able to delete your macro.

3. three

   Click Tools . It's a card item at the top of your Mac'southward screen. Clicking it prompts a driblet-down carte du jour.

4. 4

   Select Macro . This choice is at the bottom of the Tools drop-downwards menu. Selecting it causes a popular-out menu to the right of the drop-downward menu to appear.

5. 5

   Click Macros… . It's in the popular-out menu. Doing and then opens the "Macros" window.^[one]

6. half-dozen

   Click the "Macros in" drop-downwardly box. This is near the bottom of the "Macros" window. A driblet-downwards card will appear.

7. 7

   Click All Open Workbooks . It's in the drop-downwards card.

8. viii

   Select a macro. Click the proper name of the macro you desire to delete.

9. nine

   Click — . It's below the list of macros.

10. 10

    Click Yes when prompted. This will remove the macro.

11. 11

    Save your changes. Press ⌘ Command+S to exercise so. This will ensure that the macro remains deleted afterward you lot close Excel.

    Advertisement

Add New Question

• Question

  What do I do if I get the error "cannot edit a macro on a hidden workbook"?

  

  Click "View" tab. Click "Unhide". A "Personal workbook" option will announced; select this. Once inside the Personal workbook, follow the steps in the tutorial to a higher place and it should delete easily.

• Question

  What exercise I do if the Delete button is disabled?

  

  The Delete push will exist disabled if you didn't click "Enable Content" upon opening the macro. You can find this option in the yellow bar at the acme of the Excel certificate. If the Delete button is nonetheless greyed out later enabling macros, you may not have permission to edit the document.

Ask a Question

200 characters left

Include your email address to get a bulletin when this question is answered.

Submit

Ad

• On a Mac, you can also open the "Macros" window from within the Developer tab past clicking Macros.

Advertisement

• Macros can harm your computer. Unless you know where a macro came from (e.g., a trusted colleague created information technology), practise non run macros from files you didn't personally create.

Advertizement

About This Article

Commodity Summary X

1. Open the file.
2. Click Enable Content.
3. Click View.
four. Click the Macros drop-down.
v. Click View Macros and select "This Workbook."
vi. Click All Open up Workbooks.
7. Select a macro and click Delete.
8. Click Yes.

Did this summary aid y'all?

Thanks to all authors for creating a page that has been read 274,520 times.

Is this article upward to date?

Source: https://www.wikihow.com/Remove-a-Macro-in-Excel

Posted by: duboisgivat1997.blogspot.com

Share this post