Microsoft Office Tutorials and References
In Depth Information
If Not WorkbookOpen("ProductList.xls") Then
This chapter has exposed you to three layers of events: application, workbook, and
worksheet. 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.