Solution to the "Runtime Error 1004" prompt in EXCEL in win10 system

In the process of using EXCEL, win10 "runtime error 1004" sometimes occurs. This error is an error we only encounter when using macros. So if you encounter the win10 system EXCEL prompt What to do if "Runtime Error 1004" occurs? Let’s follow the editor and take a look.

1. First, open the EXCEL tool and click the file selection option above.

#2. Then click Trust Center to open Trust Center settings.

3. In the opened Trust Center interface, click Macro Settings on the left.

#4. Select the check box on the right to trust access to the VBA project object model, and finally save and confirm.

The above is the solution to the "Runtime Error 1004" prompt in excel on win10 system. I hope it can be helpful to everyone.

The above is the detailed content of Solution to the "Runtime Error 1004" prompt in EXCEL in win10 system. For more information, please follow other related articles on the PHP Chinese website!