How Excel Macros Set

Today's small series to introduce you to the Excel macro settings method, I hope to help you students.

Excel Options Setting macros

Click the Office Button, and then click Excel Options:

Click Trust Center, and then click Trust Center Settings:

After you click Macro Settings, select the appropriate option, and then click OK below to confirm the macro settings:

Save the file as a macro-enabled table

Click the Save As button, or after you click the Office Button, click Save As:

Save type location When you select Excel macro-Enabled workbook, after you enter and confirm the file name, click Save:

The icon type file, shown in the following illustration, is a macro-enabled Excel workbook file:

Enable macros when opening files

When you open a workbook that contains macros, the following prompts are set to disable all macros and give notice. Click Options:

When you select Enable this content, click OK to enable macro functionality in the workbook:

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join