How does Excel use macros?

Source: Internet
Author: User

How does Excel use macros?

Excel in the use of VBA development of Excel documents, in Excel when running the need to open Excel macro function, otherwise this document VBA Automation function will be completely shielded, the document function can not be completed.

Therefore, before turning over these Excel program files, you need to set your Excel macro security first (set for eternity, no need to set again on the same computer)

In Excel2003 edition, the following procedure can be operated:

1, click "Things"--"Macros"--"security" on the menu bar of Excel, and turn on the security dialog box shown in the following illustration.

2, in the Security Level tab, set the macro security level to Medium or low. During the introduction of the use of the "middle" level, such settings will not degrade your security, you still have a macro file has the right to automatically select whether the operation.

When the security level of the macro is successfully set, when you open the Excel program file again, you will be presented with the information box shown in the following picture, and now click on the "Enable Macros" button to make this program work:

In excel2007/2010 edition, the following procedure can be operated:

1, click the Excel Office Button in sequence (version 2010 is the file button)--Excel options, turn on the Excel Options tab shown in the image below, select "Trust Center" in the list on the left, and click on the "Trust Center Settings" button on the right side of the window.

2, turn on the "Trust Center" tab, select "Macro Settings" on the left, and select the "Disable all macros and send notifications" option in the window rendered to the right, and click OK to conclude.

After the macro security level is set successfully, open the Excel program file again, in the InfoBar (above the modifier bar) will present the following image of the warning information, now click the "Options" button opened the Office Security Options dialog box, in which select the "Enable this content" option and determined that this procedure can be normal operation.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.