How to turn on, turn off, delete Macro in Excel
Macros are tools that allow you to automate tasks in Excel. Macros help you save more time processing data in Excel, bringing greater efficiency at work. If you are new to macros in Excel, then turning on, off, and deleting macros is not well understood. The manipulation of macros is not difficult, but if you do not know, please refer to the article below.
How to turn on, turn off, delete Macro in Excel Picture 1
Here are instructions on how to enable, disable, delete Macro in Excel, invite you to track.
Turn on Macros
If you open an Excel file that contains a Macro, you will see a yellow warning bar, if the Excel file is reliable, you can turn on the Macro by selecting Enable Content on the warning bar.
How to turn on, turn off, delete Macro in Excel Picture 2
Or you can turn on the Macro by selecting File , in the Security Warning area, click Enable Content -> Enable All Content to enable all contents of the file including Macros.
How to turn on, turn off, delete Macro in Excel Picture 3
Delete Macro
Step 1 : In Excel file, select Developer -> Macros.
How to turn on, turn off, delete Macro in Excel Picture 4
Thus the Macro dialog box will be displayed.
How to turn on, turn off, delete Macro in Excel Picture 5
If you do not see the Developer tab on the Ribbon of Excel, then you do the following:
1. Select File -> Options.
How to turn on, turn off, delete Macro in Excel Picture 6
2. On the Excel Options window, select Customize Ribbon in the left menu. In the Main Tabs section on the right, you tick the box before Developer and then click OK . Thus Developer tab will be displayed on the Ribbon .
How to turn on, turn off, delete Macro in Excel Picture 7
Step 2: In the Macro dialog box , if you want to delete any Macro, click the Macro name in the Macro name list and click Delete to delete.
How to turn on, turn off, delete Macro in Excel Picture 8
Step 3 : A confirmation message appears Do you want to delete macros? (Do you want to delete the macro?) select Yes to agree to delete.
How to turn on, turn off, delete Macro in Excel Picture 9
Turn off Macros temporarily
Step 1: Click File -> Options.
How to turn on, turn off, delete Macro in Excel Picture 10
Step 2 : In the Excel Options window, select Trust Center in the left menu, then select Trust Center Settings.
How to turn on, turn off, delete Macro in Excel Picture 11
Step 3 : Choose Macro Settings, in the Macro Settings section on the right you have many options:
- Disable all macros without notification: Disable all macros and no notifications.
- Disable all macros with notification: Disable all macros that include notifications.
- Disable all macros except digitally signed macros: Disable all macros except digitally signed macros .
- Enable all macros (not recommended; potentially dangerous code can run): allow all macros (not recommended; dangerous code can run)
You select Disable all macros with notification and click OK to agree.
How to turn on, turn off, delete Macro in Excel Picture 12
So you know how to enable, disable, delete macros in Excel, now you can easily work with macros more. Hopefully this article will help you in need of learning about macros. Good luck!
You should read it
- How to turn on / off Macro in Word
- How to separate sheets into separate Excel files
- How to troubleshoot macros in Excel not working
- How to turn off content suggestions on Excel
- How to Remove a Macro in Excel
- MS Excel 2003 - Lesson 8: Excel Macro - Automate complex tasks
- How to disable Macro mode and auto-switch on iPhone camera
- What is a macro in Excel? How to create and run a Macro in Excel
- 5 source to get macro to automate Excel spreadsheets
- Attack analysis uses Excel 4.0 macros to disguise
- How to turn off, turn on Enable Editing when opening Word, Excel
- How to fix Office error 'The function you are attempting to run contains macros'