Microsoft Office Tutorials and References
In Depth Information
14. Click the Show Efficiency shape.
Excel runs the macro, which applies a conditional format to the values in the
Efficiency column of the table on the right.
15. On the Quick Access Toolbar, click the Save button to save your work.
CLEAN UP Close the PerformanceDashboard workbook.
Running Macros When a Workbook Is Opened
One advantage of writing Excel macros in VBA is that you can have Excel run a macro
whenever a workbook is opened. For example, if you use a worksheet for presentations,
you can create macros that render the contents of selected cells in bold type, italic, or
different typefaces to set the data apart from data in neighboring cells. If you close a
workbook without removing that formatting, however, the contents of your workbook
will still have that formatting applied when you open it. Although this is not a catastrophe,
returning the workbook to its original formatting might take a few seconds to accomplish.
Instead of running a macro manually, or even from a toolbar button or a menu, you can
have Excel run a macro whenever a workbook is opened. The trick of making that happen is
in the name you give the macro. Whenever Excel finds a macro with the name Auto_Open,
it runs the macro when the workbook to which it is attached is opened.
Tip If you have your macro security set to the Disable With Notification level, clicking the
Options button that appears on the Message Bar, selecting the Enable This Content option,
and then clicking OK allows the Auto_Open macro to run.