Chapter 9. launch Macros with Events

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Create custom command buttons.

  • Add additional event handlers to a command button.

  • Create worksheet and workbook event handlers.

My grandmother used to embroider names on outfits for us with her sewing machine. She had a powerful old sewing machine, with lots of pulleys and levers and loops. When she changed the thread, she had to poke the new thread up, over, and through countless turns, spools, and guides, before even getting to the needle. I still don’t know how she managed to embroider the names. She’d move levers and twist the fabric, and the names somehow ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.