Chapter 1: Getting Started with VBA
The recipes in this chapter will help you familiarize yourself with VBA in general, introduce you to the VBA working environment, and also help you edit and save your first working VBA subroutine. In the process, you will learn how to set up the development environment and how to edit your VBA coding.
In this chapter, we will cover the following recipes:
- Investigating VBA code
- Recording a macro
- Testing the macro
- Using the VBA Editor
- Editing the code by changing cell references
- Saving the file with an embedded macro
- Using the Trust Center for macro security
- Creating a customized ribbon
By the end of this chapter, you will be able to identify the need and use for a macro, record a macro, edit VBA code, and ...
Get VBA Automation for Excel 2019 Cookbook 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.
