How to start an excel macro and how to enable an excel macro

Preparation materials: computer, excel

1. First of all, open Excel and click Development Tools;

2. After that, click Record Macro;

3. The pop-up interface, we directly click OK;

4. Then we enter 123 in **, then press the enter key, and then click to stop recording;

5. Then we open another excel, and then click on macro;

6. The pop-up interface, we click to execute;

7. After that, the macro we just recorded will be executed.

Open Excel and click File in the upper left corner.

Find and click the Options button.

After the pop-up window, click Trust Center on the left.

Then click Trust Center Settings in the bottom right corner.

In the pop-up window, click Macro Settings on the left.

Select Enable All Macros and select Trust Access to VBA Project Object Model.

When you're done selecting, click OK.

Then click View in the upper toolbar.

Find the macro and click to select Record Macro.

Enter a name for the macro and save the road location, and then click OK to start recording.

After the recording is finished, click [Stop Recording] in the upper macro.

When you need to use it, click [View Macro] in the macro.

Select the macro and click Execute.

Open Excel and click the File menu to enter the next interface. Click on the option to go to the next interface. Select Trust Center and click the Trust Center Settings button to enter the Trust Center dialog box.

Click the Macro Settings tab, select the Enable All Macros option, and click OK to return to the previous page, detailed steps:

1. Open Excel and click the file menu to enter the next interface.

2. Click Options to enter the next interface.

3. Select Trust Center and click the Trust Center Settings button to enter the Trust Center dialog box.

4. Click the Macro Settings tab, select the Enable All Macros option, and click OK to return to the previous interface.

5. Click OK to return to the Excel worksheet interface, save it, close and reopen the Excel file, and then click the button to have a reaction.

Speaking of office software, when it comes to data processing, we have to mention excel, so what are the skills of excel operation, and how can you use excel proficiently? Next, let me share with you some common operation tips!

1. Excel 2010 or above

File] ribbon, select "Options" to open the excel option box.

Select Trust Center and click Trust Center Settings on the right.

Select "Macro Settings", select Enable all macros, and OK.

2. Excel 2007 version.

Office button in the upper left corner.

Select Excel Options below to open the Excel Options box.

Select Trust Center and click Trust Center Settings on the right.

Select "Macro Settings", select Enable all macros, and OK.

3. Excel 2003 version.

Tools" option, click "Options" in its drop-down menu to open the Options dialog box.

Click the Security tab (far right), and then click Macro Security under the tab to open the Security dialog box.

Click the "Security Level" tab, select "Low", and confirm.

excel**Daily office

When using Excel** for daily office, you will find that in fact**Many of the functions are not enabled, such as the mysterious "macro" function, many people don't know how to use this function, because it is gray in WPS and cannot be used.

Enable the macro function in Excel, that is, when we click on the macro, only the enterprise version of WPS can use the macro function will pop up, click the solution will pop up, **VBA installation package.

The function of the macro is to record the operation steps into a macro, and then execute the macro, which can implement some repetitive operations in batches. The steps to enable the macro function in the Excel program are as follows.

1. Open the excel program, enter the main interface of the program, click on the "File" option, and click on open.

2. Click "Options" in the window and click to open.

3. Click "Trust Center" in the window and click Open.

4. Click "Trust Center Settings" in the window and click Open.

5. Finally, check "Enable macro function" to turn on the macro function and the problem is solved.

Excel Enable Macros in Settings:Tools: Lenovo GeekPro 2021, Windows 10, Excel 2021.

1. Open the excel document.

2. Click on the file option in the upper left corner.

3. Select the click option in the pop-up dialog box.

4. After entering, select and click Trust Center in the left sidebar.

5. Click the Trust Center Settings option in the pop-up system page.

6. After entering, you will find that the enabled macro hunger beam is on the right side of the page.

7. Click OK in the lower right corner to enable macro luck.