Record Macro using Excel VBA

Learn to Activate Excel Developer Tab and Record Macro using Excel VBA

Hi, there. In this Excel VBA tutorial video we'll learn how to activate the developer tab on your Excel ribbon. You notice that while working with Excel, I have been frequently being using the developer tab. Well, most of you who would not have worked with Excel macros earlier, would not find this on your screen. So I'll show you how to activate this in the version 2007 and the versions thereafter.

So first in Excel 2007

So how do I know its Excel 2007 version. Well, the moment you see this office button the one is in a circle and shape, that means it is Excel 2007. So if you have this circle button on your screen that means you are using Excel 2007 and to activate the developer tab, you must click on the circle button ones. Down below you will notice Excel options. Click on that. And when that the option of popular. Once you go inside popular, you will notice the third option from the top which says show developer tab in the ribbon. Well, once you click on it then it will show the developer tab in.

In Excel 2010, 2013 and 2016 version.

lets see how to activate Macro Excel Developer Tab. We go to the file menu on the top left. Down below you find options. I click on options. Within options you will not find the popular tab as you had found this in the 2007 version of Excel. Well, this time you will have to go to customize ribbon tab. Well, the logic is this entire section of the Excel top hand screen is called Ribbon. And you wish to add one tab on it. Hence, you are going to tell customized ribbon. Within the customized ribbon, you skip this one dialogue box and go to the next one. You notice a list of all the tabs. Well on my screen the developer, check boxes are ticked on. In your case you'll have to tick it on as well. And once you press okay, you will notice on the top right corner of the ribbon, you will find developer tab.
So this was all about developer tab.
Now, Before we start working with macros, let's just go through some of the very basic important information because that will help us save our work correctly and execute our work correctly. Now what I notice on my screen the one of the files which contains macros, the extension of the file name happens to be .xlxm. Not the .xlsx that you have worked regularly on a day to day basis.

Why you should save macros enabled workbook as .xlxm?

If you happen to record or write a code in your file and wish to save this for future use, you must tell Excel, that look this has to be a macros enabled workbook. And you must save it accordingly. Macros if saved in the xlsx format will not reactivate or re-execute or get saved for future after you have closed the files once.
So if you're ever you're working with a macro, please ensure that you're saving this in xlsm. Now it's not that difficult. Why? Because you can go to file. Saves as... now let's say I wish to save this on one of my modules. Let's go on modules. And you will notice from the drop down it gives you a variety of options, one of which says macro enabled workbook.

Now some of you, may not get this extension listed out here because that's one of the folder options settings from the PC which you have to activate. So it's quite useful to have this setting activated. And I'll show you that. So I go to the window option. Window X is a shortcut which I'm pressing. It allows me to go to control panel. Either way you might access control panel from your PC.
Once you activate control panel, one of the options you might get after you check on the small icon or the large icon is folder option. Let me go to folder option. Yeah, press the letter F, it takes you to folder option. Go to folder options and then go to view tab. Within view tab, there is one setting probably seventh or eight, yeah, which says, hide extensions for known file types. Now by default, it is switched on. If it is switched on, you'll not be able to find the extension so easily listed out on the desktop or in the saving panel. Now press okay and cross this out. Now save this in the same folder. Let see, what you get. Notice you don't get an extension of the file. Just get the macros enabled workbook. Well, Prefer to have that extension shown.
Hence, Go back to the Control Panel setting. Go to the folder options. And make sure that go to the View tab and check this box off, which says "hide extension for known file types". Apply this and press Ok. So henceforth, save all our work in the .xlsm or macro enabled workbook.

Learn Excel programming without any programming knowledge and automate task faster.

I believe the outcome of your learning should benefit you sooner rather than later. You should not be waiting until the end of Chapter 4 to start getting a taste of your efforts. And that's why I have taken the liberty to change the sequence of topics and use a "get the work done" approach. My promise – 1st hour of this course has the potential to save your 100s of hours right away

-Rishabh Pugalia Microsoft office Expert


Excellent Course & worth learning it to improve your excel skills

The course itself was designed in very good way having step by step & logical approach to explain the concepts & logic that will make things easy to remember in future. This definitely will help to improve my work as I work extensively with excel.

a student at yoda learning solutions

- Ashraf Halai
CPA, CA at Aviation & Aerospace

Very helpful what you will learn will save you lots of time"

if you are a regular user who performs complicated tasks in Excel on daily basis, you are likely to take that back within a week. The author's delivery is very efficient. Highly recommended.

a student at yoda learning solutions

- Ivan Arnaudov,
Owner and CEO at Business Ventures International LLC

Are you ready to start learning?

Join Now

If you're not completely satisfied, let us know within 30 days for a full refund. We want you to be 100% satisfied.