MM0002 - 09/12/19 - Cool Workbook Event Macros

You probably know how to trigger a macro using a button.  Did you know that's just one of many ways to trigger a macro.  Excel 'events' - such as opening a file, changing sheets or editing a cell offer us opportunities to trigger macros that create value for the user.  Warning: appreciate the pros AND cons and handle with care!

Topics

  •  | Worbook Event Macros - Concept
  •  | Worbook Event Macros - Warning
  •  | Worbook Event Macros - Set Up In VBA Editor
  •  | Worbook Event Macros - Worksheet Change
  •  | Worbook Event Macros - Target A Cell
  •  | IF Statement - Single Line
  •  | Message Box - Simple
  •  | IF Statement - IF - ELSE - END IF
  •  | Worbook Event Macros - Complete Example
  •  | Use The Right Tools
  •  | Worbook Event Macros - Worksheet Activate
  •  | VBA To Scroll To Top Left

1 Lesson