What are the functions of Excel macros?

1. Record macros. If you keep repeating the same operation several times. First of all, we want to record a new macro, which is simply to record the steps we want to repeat the operation by:

Click Tools - Macros - to record a new macro. After clicking, you will start to enter the macro recording, and record your exciting search step by step.

2.Manage macros, after the macro is recorded, you can use the Visual Basic machine to view the macro** to achieve the purpose of correcting errors or changing the macro. For example, if you want a macro that you want to use for text wrapping, you can also make the text bold, you can record another macro that makes the text of the missing cell bold, and then copy the instructions in it to the macro that wraps the text with obvious losses.

3.Macro security, which provides security in Excel against viruses that can be spread through macros. If you share a macro with others, you can use the digitally signed method (Digital Signature:

An electronic, cryptographically based security verification stamp on a macro or document. This signature confirms that the macro or document came from the issuer and has not been tampered with. ) to verify the true reliability of other users, so that you can guarantee reliability for other users**.

So whenever you open a workbook that contains macros, you can use the method of verifying the macros first and then enabling the macros.

Summary: 1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click options. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. 3. Click the development tools option in the single column of Caizen Bend, and then click Record Macro. 4. Fill in the name and shortcut key, set the save location, and click OK.

5. Change the color of excel** to red. 6. After the Excel macro is recorded, you can click to stop recording. 7. Click the mouse to other positions, and then press the shortcut key to modify the color.

Demo environment information: computer model: thinkpad wing 14 slim, system version: window10 home Chinese version, software version: excel2020.

Steps: 1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click Options. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. The specific operation steps are shown in the following figure: 3. Click the development tools option in the menu bar, and then click Record macro.

The specific operation steps are shown in the following figure: 4. Fill in the name code raid wheel, shortcut key, set the save location, and click OK. The specific steps are shown in the following figure:

5. Change the color of excel** to red. The specific operation steps are shown in the following figure: 6. After the Excel macro is recorded, you can click to stop recording.

The specific operation steps are shown in the following figure: 7. Click the mouse delay message to other positions, and then press the set shortcut key to modify the color. The specific steps are shown in the following figure:

Note: The above operation steps need to be operated in order, and do not shuffle the order.

Excel's macro function can help users automate repetitive operations and improve work efficiency. Here are the steps for using the macro feature:

Open the excel file and click "Macros" in the "Development Tools" tab, or use the shortcut "Alt+F8".

In the pop-up "Macro" dialog box, enter a macro name and click the "Create" button.

In the Microsoft Visual Basic for Applications window that pops up, write a macro for **. **The writing needs to use VBA language, you can refer to the relevant VBA tutorial to learn.

Execute macros in an excel file. You can use the shortcut key "Alt+F8" to open the macro dialog box, select the macro you want to execute, and then click the "Run" button.

It should be noted that using the macro function is risky and needs to be done with caution. When writing macros, it is necessary to ensure the correctness and security of the macro to avoid data loss or other adverse consequences caused by incorrect operations.