Excel VBA recorded macros cannot be executed

Mere recording is only enough for general needs.

Look at your features that need to be extracted dynamically.

If you don't make any changes after recording, you just can't meet the requirements!

Recorded macros are executed only once.

Wouldn't do anything else!

shape, the object in the drawing layer is not specified. Modification:

sub macro4()

falsetext:="xy3:" & chr(10) &""

with , 90, 90, 90, 50)with

#= msolinesolid

msolinesingle

# msotrue

rgb(0, 0, 0)

rgb(255, 255, 255)

msotrue

rgb(255, 255, 255)

rgb(255, 255, 225)

end with

3).range("a1").selectend sub

1. First of all, we click to open the excel on the computer, and then click on the development tools in the toolbar;

2. In the pop-up interface, we click Record Macro;

3. In the pop-up interface, we don't change the macro name, and then click OK;

4. Enter the content of the recorded macro in **;

5. After that, click to stop recording macro;

6. Then we select any cell in **, and then click the macro in the toolbar;

7. In the pop-up interface, we select the macro we just recorded, and then click Execute;

After opening ** first on your computer, click on the Developer Tools tab.

Then, in the tools options that open, click to find the ** project group.

Then click the "Record Macro" button as below screenshot shown.

Then, in the window that opens, click to enter the "Macro Name" content as shown in the image below.

Click to enter the content of the "shortcut key", and the "Current Workbook" button is saved by default.

Finally, click the "OK" button to complete the setup.

After opening ** first on your computer, click on the Developer Tools tab.

Then, in the tools options that open, click to find the ** project group.

Then click the "Record Macro" button as below screenshot shown.

Then, in the window that opens, click to enter the "Macro Name" content as shown in the image below.

Click to enter the content of the "shortcut key", and the "Current Workbook" button is saved by default.

Finally, click the "OK" button to complete the setup.

Open Execl, in the menu "Help" About Microsoft Excel"The disabled item in the pop-up window in this item is not there this file, and if so, it can be enabled. This is because after an illegal Excel operation was closed, the file was disabled for security protection.

Review your security settings and macro security.

Doesn't turn on automatically, or can't it open? alt+f8, or alt+f11.

It's really not good, reinstall the office, the office encounters an inexplicable problem, and it can't be solved for a few days, so it's reinstalled.

Excel Options - Add-ins - Manage - Disable Projects, click Go, and select Start.

1. First of all, we click to open the excel on the computer, and then click on the development tools in the toolbar;

2. In the pop-up interface, we click Record Macro;

3. In the pop-up interface, we don't change the macro name, and then click OK;

4. Enter the content of the recorded macro in **;

5. After that, click to stop recording macro;

6. Then we select any cell in **, and then click the macro in the toolbar;

7. In the pop-up interface, we select the macro we just recorded, and then click Execute;

Tools Materials.

Excel software for computers.

Here's how. 1. First open the excel software, and find "Record Macro" in the toolbar as shown in the figure below.

2. As shown below, enter the name of the macro.

3. After the input is completed, enter the following interface and click the "OK" option.

4. As shown below, click any one of Excel to enter the formula.

5. Then click "Stop Recording" in the toolbar to stop recording.

6. Finally, click Save, open the file again and you can use the macro normally.

My own, settled.

DOWN EXCEL2010 Standard Edition (Cracked Edition).

Find the shortcut to excel in the program list, right-click and select Run as administrator, then Focus.

Use this excel window to open the ** you want to use, and then record.

It should be a matter of permissions, and administrator privileges are fine.

It won't be that your excel is defective installed.

Disabled, to be exact: just enable it.

excel 2002-2003: help>about ms excel>disabled items

excel 2007 : office button>excel options..add-ins

in the "manage:" dropdown (bottom of the dialog)

choose "disabled itemsgo

Steps to record macros in Excel2010:

First open Excel2010 as below screenshot shown.

Find the "Development Tools" menu item, it should be noted here that the "Development Tools" menu is not the default menu of Excel2010, you need to add it yourself, how to add it for other experiences.

Click "Record Macro" to start the recording of your own defined macro. Then you also need to explain what a macro is, students who study mathematics know functions, in fact, macros are just a process defined by the user himself.

Then give the macro a name, the default name of the system is as follows "macro 1", click OK.

When we hit enter, the ribbon becomes operable, and then we find the "Stop Recording" button, as shown in the image below.

After the above operation, we have successfully recorded a macro that inputs a function into the cell, and if you want to do something similar in the future, then you only need to call this macro.

It's better to grab a picture and look at what the problem is.

1. First of all, we click to open the excel on the computer, and then click on the development tools in the toolbar;

2. In the pop-up interface, we click Record Macro;

3. In the pop-up interface, we don't change the macro name, and then click OK;

4. Enter the content of the recorded macro in **;

5. After that, click to stop recording macro;

6. Then we select any cell in **, and then click the macro in the toolbar;

7. In the pop-up interface, we select the macro we just recorded, and then click Execute;