Current location - Education and Training Encyclopedia - Resume - I set a macro in Excel and don't want to use it. How to cancel a macro?
I set a macro in Excel and don't want to use it. How to cancel a macro?
1, this macro can only be run or deleted when the macro's security level is low, but Excel

By default, "Macro's security level is high", so when you open a workbook containing macros, you will get the following prompt:

2. Click OK to open the workbook, and then click Tools > Macros-> Security Opens the Security dialog box.

2. In the dialog box, select "Low Security Level" and "OK" to exit.

3. Close Excel, then run Excel and open the workbook. You can't see the hint in the first picture.

4. Click the menu "Tools > Macro->; Macro Opens the Macro dialog box.

5. In the Macro dialog box, list the macro names, select them, and then click the Delete button.

6. For security reasons, you can reset the Macro Security Level to high as mentioned above.

7. If you open the workbook where the macro has been deleted and the prompt of the first picture still appears, you can click the menu "Tools->; Macro-> visual

basis

Edit ".

8. Find the "Modules" folder in the item list box on the left side of the editor window, and double-click it to expand it.

9. Right-click Module 1, and then click Delete Module 1. (If there are other modules, delete them, too. )

10. Click No to delete the module folder. Close the editor and return to the workbook state.

1 1. Save the workbook.

Note: visually

basis

If there are other modules in the editor, you should also delete them.