Home page
Astronomy education
ImagineIT Toolbar for Excel
Resources for Warwick students
Publications
Mathematics in Action book
Knowle Astronomical Society
Photography

How to set Excel to allow macros to run

Instructions

  1. Start Excel.

  2. Go to the Tools menu, then Macro, then Security . . .

  3. Click the Security Level tab at the top.

  4. Choose Medium for the security level.

    (This means that you will be asked if you want to enable macros each time you open a spreadsheet that contains them.)

  5. Click OK.

    You will now be able to use spreadsheets containing macros.


Richard Beare    22nd July, 2004