Questions about Excel macros 50

Excel automatically integrates the VBA high-answer level programming language, and the programs compiled in this language are called macros.

1. Macro can be understood as a recorder, which can realize the operation recorded in Excel again.

2. If you often use Excel for data processing and need to repeat a certain task.

3. Excel macro has a powerful function library, which can be used to do various operations conveniently.

4. Excel macro can also generate a variety of clear judgment charts to reflect your data vividly.

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 menu bar, 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.

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 steps are shown in the following figure:

3. Click the Development Tools option in the menu bar, and then click Record Macro. The specific steps are shown in the following figure:

4. Fill in the name and 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 steps are shown in the following figure:

6. After the Excel macro is recorded, you can click to stop recording. The specific steps are shown in the following figure:

7. Click the mouse to other positions, and then press the 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.

Method: 1. If you open Excel, you will be prompted to enable macros, and you can close it normally.

2. After that, go to the worksheet, click the office icon in the upper left corner, "Excel Options" - Trust Center --- Trust Center Settings.

3. After that, click "Macro Settings" on the right side, and set it to "Disable all macros and don't notify" or send a notification.

4. If you don't need macros, you can also press Alt+F11 to enter the VB window, double-click each worksheet or module or thisworkbook in the left project resource window, if there is ** in the **window that pops up on the right**, delete **, and then save and exit, next time the annoying dialog box will not pop up.

Note: Although the macro is deleted in the macro list, it does not mean that the macro is completely cleared, and it is still saved in the vb window, so you must find it in the window to delete it.

The dialog box of the macro,The key point is to enable the macro to open the file,Close the file and open it again,Open Excel and the macro will appear.

When opening the excel sheet, the macro always appears, which is generated by the macro without a digital signature, you can open the workbook after clicking on the tool option Security

If you set the macro to low in macro security, you won't have this problem. If it is set to Medium, it will prompt whether to perform macro operations every time you open the macro, such as.

If the height is high, then only digitally signed macros can be run, and other macros cannot be run.

A friend asked: Open the workbook that contains the macros you want to delete. On the Tools menu, point to Macros, and then click Macros. In the Macro name box, click the name of the macro you want to delete. Click Delete. But when I do it this way, I don't have any names in the Macro Name box.

Press Alt+F11 to enter the VB window, and double-click each worksheet or module or ThisWorkbook in the project resource window on the left, for example.

If there is ** in the **window that pops up on the right**,Delete it,Then save and exit,Next time that annoying dialog box won't pop up。

Note: Although the macro is deleted in the macro list, it does not mean that the macro is completely cleared, ** is still saved in the vb window, so it must be returned.

You have to find the deletion in the window.

It is also possible that Excel was not installed when you installed it, so it is recommended that you uninstall Excel in the program and then reinstall Microsoft Office.

Disabling macros closes the workbook, and when we send the bookbook to someone else, someone disables the macro so that our macro won't be executed, and opens ours.

The workbook is down, now we want to implement this, disable the macros we write, then close the workbook, don't let us open our workbook, and let him enable us.

The macro can open the workbook, and then encrypt your project, so that we can write a simple macro ** protection, hehe, this protection.

It's relative, and it's easy to crack, but it's safe for novices and friends who are not familiar with VBA!

Calendar controls are missing.

What to use wps if you have nothing to do, copycat office is nothing less this less that, macro modules are all strongly installed.