Hour 20. Automating Tasks with Macros and Smart Tags

The highlights in this hour are as follows:

  • What a macro is and what it can do for you

  • How to create a macro

  • How to run a macro

  • How to fix macro errors

  • How to attach a macro to a toolbar

  • How to use a macro in other workbooks

  • How to prevent macro viruses

During this hour, you will learn how to use macros to simplify your work in Excel, making you more efficient and leaving time for other things you need to do on the job. Macros are not difficult to create and use. They are special instructions that control how Excel functions.

The To Do exercises in this hour show you how to automate Excel through macros. You learn how to create, record, run, edit, and delete macros in one hour. You create a simple ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.