How to create Excel macros and automate your spreadsheets Use macros to combine multiple tasks into a single, one-second transaction.

It should be set to allow you to enable macros on a case-by-case basis, mainly for the macros in documents that you create.