Teaching Resources > KS3 > Mathematics >

Enabling macros

Enabling Macros

These resources will run on Excel 2000®, Excel XP® or Excel 2003®

For these spreadsheets to work you must enable the ANALYSIS TOOLPAK and ANALYSIS TOOLPACK VBA settings.  This is found in the TOOLS menu, ADD-INS.  Place a check next to ANALYSIS TOOLPAK.

Add-ins selection        Select analysis toolpak

To run these resources you must set your security settings in Excel to medium.

To do this:

  • Click on Tools and then select Macro followed by Security from the drop down menu.

tools - macros

  • Click on the Security Level tab and select Medium

.security

  • Click OK and then close Excel

When you open the resource make sure you enable macros.

Enable macros

Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation