The purpose of macros is to automate common tasks. Although some macros only record keystrokes or mouse clicks, developers can use VBA (Visual Basic for Applications (VBA)), which is the macro language version of Microsoft Visual Basic, to write applications based on Microsoft Windows, which is built into several Microsoft programs. ) macro, you can run multiple commands on your computer. To reduce the security of a macro, you can open it directly. The specific operation is: click Tools-Macro-Security-Low.
In addition, VBA macros can lead to potential security risks. Hackers can introduce malicious macros through documents. Once the document is opened, malicious macros will run and may spread viruses on the computer. It is recommended to kill macro virus.
Here is a detailed, you see:
Prompt that this document has macros. The macro language function of this application has been cancelled. Unable to use VBA required by the function. Do you want to open this document as read-only?
This error may be caused by the following reasons:
Macro security is set to:
Very high. The application has signed a macro, but the macro is automatically disabled. Use the following steps to enable macros:
Select the Tools menu option, and then select Macro Security. Click the high button in the security dialog box to set the security level to high.
Close the file and any other instances of applications currently running on the computer (close any applications that use the currently running applications).
Open the file again, and then check the details of the trusted certificate. If you trust the certificate issued by this publisher, check Always trust macros from this publisher.
Click the Enable button to allow the macro to run.
The "Gao" application has a signed macro, but you selected "Disabled" in the macro warning box when you opened the file. Use the following steps to enable macros:
Close the file and any other instances of applications currently running on the computer (close all applications currently running).
Open the file again, and then check the details of the trusted certificate. If you trust the certificate issued by this publisher, check Always trust macros from this publisher.
Click the Enable button to allow the macro to run.
"High" or "very high". Macros are unsigned and will be automatically disabled by the application. If you have confirmed that you can trust the source of unsigned macros, use the following steps to enable macros:
Select the Tools menu, and then select Macro Security. In the security dialog box, click the option button and set the security level to medium.
Close the file and any other instances of applications currently running on your computer.
Open the file again, and when prompted to allow unsigned macros to run, click Enable.
After accepting the macro, please reset the macro security level to the original setting.
Another application instance has locked the security settings, and no changes to the security settings are allowed.
When you need to change security settings, it is recommended that you close all Office-related applications or other instances of the application.
Visual Basic for Applications(VBA) is not installed on the computer.
If VBA is not installed, you will not be able to accept reliable certificates attached to VBA macros. Therefore, any VBA macro you try to run, even with a reliable certificate, cannot run because the necessary macro interpreter is not installed in the system. There are two situations that can cause this error:
The administrator chose not to install VBA.
By default, VBA is not installed on the version of Office you are running.
If the Office you are running does not provide the function of installing VBA, you will need to upgrade the version of Office to run VBA macros.
The trusted certificate is invalid-(in this case, you cannot select the Enable button).
The certificate is no longer trusted, has been revoked by the issuing authority or is damaged. There may be several other ways to determine why the certificate is no longer recognized as valid by the system. It is recommended that you do not trust or run macros with invalid certificates.
You can find troubleshooting help topics related to this problem online.
Please check the details about this error message online.