Microsoft Office Tutorials and References
In Depth Information
Running macros when a workbook is opened
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.
CLEAN UP Close the PerformanceDashboard workbook, saving your changes if you
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.