From the course: Excel: Macros and VBA for Beginners (2021)
Join today to access over 24,200 courses taught by industry experts.
Add the Developer tab to your ribbon - Microsoft Excel Tutorial
From the course: Excel: Macros and VBA for Beginners (2021)
Add the Developer tab to your ribbon
- [Instructor] So one thing that's mysterious about macros and VBA is this, where do they live? Well, notice in my ribbon, there is no developer tab. That's where the code lives. By default, the developer tab is not enabled. We have to manually enable it. I'm going to go to file, options. Customize ribbon. Notice, developer, this box needs to be checked. Click okay. There is the developer tab. Let's click on it and look at some things. Developer, there are three buttons I want to point out to you. First of all, the macros button. So I'm going to click that. It's where we would see any macros in either all open workbooks as the macros in has defaulted to or we could look at macros in this workbook only. This is also where we can launch macros. It's canceled out. The other button is record macro. That's one of two ways where we can start a recording. Another way to start recording a macro is the icon in the lower…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.