For example, the SheetActivate event occurs for the Application, Workbook, Worksheet, and Chart objects (for Worksheet and Chart, it’s simply called the Activate event). The difference is only in the scope: while Workbook applies to the whole file independent of worksheet, Worksheet applies only for a specific worksheet.You’ll notice that some of the same events occur for a number of objects. Note that some events exist for both Workbook and Worksheet locations.
'"WorkBook" is the location and "Open" is the eventĮxecutes the statement when the workbook is openĮxecutes the statement immediately before the workbook is closedĮxecutes the statement immediately before the workbook is savedĮxecutes the statement immediately before printingĮxecutes the statement immediately after the workbook is savedĮxecutes the statement every time a worksheet is activatedĮxecutes a statement every time the user double-click a cellĮxecutes a statement every time the user right-click a cellĮxecutes a statement every time the content of a cell is changedĮxecutes a statement every time a value in a worksheet is calculated or recalculatedĮxecutes a statement every time a new worksheet is createdĮxecutes a statement every time a hyperlink is clickedĮxecutes a statement every time the selection changesĮxecutes a statement every time the worksheet becomes activeĮxecutes a statement every time the worksheet becomes deactivatedĮxecutes a statement when a cell in the worksheet is double-clickedĮxecutes a statement when a cell in the worksheet is right-clickedĮxecutes a statement every time a value in the worksheet is calculated or recalculatedĮxecutes a statement every time the content of a cell in the worksheet is changedĮxecute a statement every time a hyperlink is clicked on the worksheet
0 kommentar(er)
