Question about Computers & Internet

2 Answers

Macro on excel

Sir gud day!!!!!!

pls do help me w/ regards on using macro on to do it? on easy step by step procedure for i am just a novies to kind of stuff....

thanx and more power....


Posted by on


2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    Visited the website for 3 consecutive days.


    An expert who has answered 20 questions.

  • Expert
  • 35 Answers

VBA Macros Programming & Automation Reporting in Microsoft excel Practical Certification Training Course Institute in Delhi NCR, we provide a weekend classes with live project session & 100% Job Placement Assistance after 70% Course Completed.
To know more visit our site-

Posted on Mar 13, 2018

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer got voted for 20 times.

  • Expert
  • 171 Answers

Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.

Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

Posted on Jan 28, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Office 2010 on my computer will not macros or save alterations to style sheets

Hello there
try this! and hope it will help!

  • Click the Microsoft Office Button , and then click Excel Options.
  • Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  • Click the options that you want: Disable all macros without notification Click this option if you don't trust macros.

Apr 23, 2017 | Microsoft Office Home and Student 2010

2 Answers

Hi sir Gud morning i have an lg gd510 pop mobile phone but it is not playing online videos like Youtube simlpy showing chech APN settings pls help me

hi sir Gud morning i have an lg gd510 pop mobile phone but it is not playing online videos like Youtube simlpy showing chech APN settings pls help me

Jul 01, 2011 | LG GD510 Cell Phone

1 Answer

Hi gud evng sir, I forget my security code of NOKIA 3110classic free download for unlocking very easy to use

May 29, 2010 | Nokia 3110 Cellular Phone

2 Answers

What do you mean excel macro

is a hiden process of Excel, is like program or several steps ( like moving cursor, make calculations, moving files, is no limit what can do, but normaly is not visible, is low level programing is always used for virus spreeding.

Jan 14, 2010 | Computers & Internet

1 Answer

Forgot My Security Code..plss help me Sir!

Only Nokia Care can help you re-install the firmware. And do not use any codes in future.

Aug 05, 2009 | Nokia 5300 Grey Cellular Phone

1 Answer


Hi motilal

Follow these steps to create multiple macros

Click the Microsoft Office Button , and then click Excel Options.
In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.

In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.


May 06, 2008 | Microsoft Excel for PC

1 Answer

Macro in excel

Open up your Excel and hit ALT + F11. This opens up the VBA editor.
You can then right click and click New Module and write your macro in there.

Mar 22, 2008 | Microsoft Excel for PC

1 Answer

Macro to be used in Excel

Instead of me teaching u. i would suggest u learn it by following the simple steps.

1. Click Tools > Macros > record
2. do some common operation like copying data, creating graphs, etc.
3. press alt+F11 to go to vb editor, to see ur macro recorded
4. study it ... u will learn easily


try the book 'Microsoft Excel Visual Basic Macros Examples' at


have a nice day

Jan 26, 2008 | Computers & Internet

1 Answer

How to use macro in excel

show the macro toolbar then click on the record button.

Sep 21, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

362 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides