From the course: Excel: Macros and VBA for Beginners

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Add the Developer tab to your ribbon

Add the Developer tab to your ribbon - Microsoft Excel Tutorial

From the course: Excel: Macros and VBA for Beginners

Start my 1-month free trial Buy for my team

Add the Developer tab to your ribbon

“

- [Instructor] One thing that's mysterious about macros in VBA is this question of where does it live? Notice, in my ribbon, there is no Developer tab. That's what we need. By default, the Developer tab is disabled. We have to manually enable it. Here we go. File. Options. Customized Ribbon. And over in this right side, I'm going to scroll down a little bit, Developer is not checked. I'm going to check it, and OK. Now we have the Developer tab. We're not going to record a macro now, but I do want to show you a few things. In the Developer tab, we can select Macros. This will show us any macros, and it's defaulted to show us macros in all open workbooks. We can also show this workbook only, but we don't have any, of course. I'm going to Cancel. From here, there are two ways that we can start recording a macro. We can start recording a macro from that Code group in the ribbon with the Record Macro button. We can also start recording the macro from that icon in the lower left, the square…

Contents