How to Create Macros? - Computers & Internet

When you open Word 2010, click on the "View" tab. The "Macros" button will be on the far right. Clicking on the button will allow you to create and edit macros.

From the excel help file

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Click the options that you want:
   • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
   • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
   • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
   • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
   • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

you can find more information about macro and usage of macro from
Automate computer tasks easily with macro software

You can create a macro by using the macro recorder to record a sequence of actions, or you can create a macro from scratch by entering Visual Basic for Applications code in the Visual Basic Editor.
Open a new document.
From the Tools menu, choose Customize.
Click the Commands tab and then scroll down in the Categories box and select Macros. You’ll see the names of any macros you've created in the Commands box on the right-hand side.
Click, hold, and drag your macro onto any toolbar and release, as shown in Figure D. A button with the name of the macro will appear on the toolbar.

Macros are harder to understand than they are to create and use. Let me repeat "Macros are harder to understand than they are to create and use."
Here is the only understanding that you need. "they are used for repetive tasks" .

Now to the simple part of creating then using.
Get into your work and identify a task that you want to created macro for, Kapish? Just before you start on the task go into the macros screen and tell it to "create", then do your task. When through "push the stop button. Name the micro and save it. (the name may be the first step if so then give the darn thing a name, no big deal). The next time you are in the exact field where the identical task is going to be perforned you can call up the micro to run through the key strokes for you. Get ready for wildly unexpected results, with those understood you can go into the code and modify it. Or you can delete it and create anotherone that is cleaner. Keep doing this until you get the bugs out. By the way the once created micros leave a tag in the spreadsheet that alerts everyone that opens it to watch out for the dreaded micro you created.

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.

Regards,
TheAssembler

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:

http://www.anthony-vba.kefra.com/

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

or

try the book 'Microsoft Excel Visual Basic Macros Examples' at http://www.add-ins.com/vbexamplestopics.htm


bye

have a nice day

Macros are stored in one of two places, Irene - and you decide where and when you create one. When you select Tools -> Macro -> Record New Macro you’re prompted to either create the macro in the global template (normal.dot) file, or the document you’re currently working on - by default, normal.dot is selected so that the macros are available in all documents you create.

Your normal.dot file is also where all custom styles, toolbars and autotext entries are stored, and it’s possible to transfer all of these - plus your macros - from one machine to another courtesy of Word’s Macro Organizer tool. The walkthrough below explains how to access it and back up your macros to a file you then transfer to your second PC before copying those macros into the normal.dot file on that computer so the macros are accessible from there too.

While this tool is the best way to transfer macros, or other individual elements of your normal.dot file (just select the appropriate tab to transfer styles, toolbars and autotext entries in exactly the same way), if you’re migrating to another PC you may wish to take all your settings with you. If you have Office 2000 or later you can use the Save My Settings Wizard to back up all your Office customisations - including the normal.dot template - and then use the same wizard on your new computer to restore them to the version of Office installed there.

Office XP and 2003 users will find the tool installed with Office -access it from the Microsoft Office Tools menu on the Start -> All Programs menu; Office 2000 users need to download it from here. It’s called the Microsoft Office 2000 Profile Wizard here.

Macro is a simple way to automate tasks in Microsoft Office programs. It allows advanced users to program or create their own commands in Office, thereby automating tasks. For example, a user might want to create a table with four values already in them. The user could create one, and then copy it, and paste it. However, when you restart your computer, that data is lost. Unless you open the old document and copy the table, you'll have to start all over again. Macros helps you do your tasks. By recording the table creation to a macro, creating the same table over and over is just a simple macro away.