Key Points

• Add a custom command button to a worksheet to provide an easy way to launch a macro. Give the button a meaningful name before you create an event handler for it.

• Assign a MouseMove event handler to a control to get extremely frequent events that don’t even require a click. Use the Shift argument of the MouseMove event to fine-tune the behavior of the event handler.

• If you want a worksheet event handler to run for any worksheet in the workbook- including new worksheets-create the event handler at the workbook level.

• Any event handler that begins with the word Before can be cancelled. Just add the statement Cancel=True to the body of the event handler to block what Excel would otherwise automatically do with that event.