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.