Automatic Procedures and Events

In This Chapter

^ Knowing the event types that can trigger an execution ^ Finding out where to place your event-handler VBA code ^ Executing a macro when a workbook is opened or closed ^ Executing a macro when a workbook or worksheet is activated

■ X ou have a number of ways to execute a VBA Sub procedure. One way is to arrange for the Sub to be executed automatically. In this chapter, I cover the ins and outs of this potentially useful feature, explaining how to set things up so that a macro is executed automatically when a particular event occurs. (No, this chapter is not about capital punishment.)

0 0

Post a comment