streetnoob.blogg.se

• #How to write a macro in excel 2007 series#

So this is how we can use macros in our MS Excel sheet.

Now selecting any particular cell and pressing the shortcut key which we saved for our macro will work and change the format of that cell to our requirement. One thing which we need to know that changes made in macro cannot be undo.

Now we will apply our macro in our Excel sheet. And then press the recording button from our status bar to stop. Now from our home tab we can select our required task, like bold, fill background color, change font size or change font color etc. And at last some description will be asked.Īdding description is important because whenever other user of our team or group is working on this particular excel sheet then he/she can understand that why this macro was made for.Īnd then when we finish adding our macro we will be able to see a recording sign in our status bar, which shows that your macro is being recorded. Then we will ask to set the storing location of our macro, like for this particular excel sheet or throughout our MS EXCEL. We can also find it in our VIEW tab.Īs we open it we will first asked to name our macro, and then set any particular shortcut key for it. Now suppose if we want to make any macro of ours than we can do that by creating a macro.įor that we will first right click on our status bar and then we will see certain options of status bar, we will use macro recording option.

#How to write a macro in excel 2007 series#

Macros is a series of step recording which can be replaced by particular icon or keyboard shortcut. In this detailed guide, I will cover all that you need to know to get. What if we need to do such kind of thing for or many cells. Even if you're a complete newbie to the world of Excel VBA, you can easily record a macro and automate some of your work. Suppose if we want to perform certain operation like changing the font style or making them bold or underlining them or changing their background color to any cell than we need to perform certain steps for that. Now we will see that how we can use macros in MS Excel.