Page 306 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

If Not WorkbookOpen("ProductList.xls") Then
Workbooks.Open "ProductList.xls"
End If

This chapter has exposed you to three layers of events: application, workbook, and work-
sheet. When analyzing the needs of your workbook, it’s important to remember your final
goals for your project. When you have a list of event procedures that are required, the next
step is to determine at which level the procedures should be stored. Remember that the most
common error while programming event procedures is coding the events for the wrong object.
Keep in mind as you are programming the required event procedures that some triggers
actually cause several events to run. The best way to get a feel for event procedures is to
thoroughly test them. You might go through several drafts before you finalize how you want
to set up your event handlers.

Chapter 12

280
Part 4: Advanced VBA