O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Running a Macro When a Workbook Is Opened

Running a Macro 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, italics, or different typefaces to set the data apart from data in neighboring cells. If you should close a workbook without removing that formatting, however, the contents of your workbook will have highlights when you open it. While this is not a catastrophe, returning the workbook to its original formatting will take only a few seconds to accomplish.

Rather ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required