Question

Describe macros? How can you record macros run it and assign to buttons in ms word/ms Excel. please give long answer

Answer 1

Macros: -  Macro is a tool that enable us to automate the frequently used task.

Typical uses of Macros are:

• To speed up routine editing and formatting.

• To complete multiple commands - such as to insert a table with a specific size and borders, and with a specific number of rows and columns.

• To automate the complex series of task.

• You can use the macro recorder to record a sequence of actions.

To record macros follow the instructions given below: -

• In MS Word go to View tab.
• Click on Macros drop down button and then click on Record Macro.
• You will see the dialog box of Record Macro.
• Here this gives you a field for Macro Name. Fill the name as you wish as per your work.
• Then you will see Assign Macro to Button or Keyboard button.
• Next You will see Store Macro in option. Here you will be able to choose the option All Documents or Current document.
• Next you will see description section. Here you can describe the Macro. It is not recommended.
• If you have choosen Keyboard option on Assign Macro to. Then you can customize the shortcut key by pressing on keyboard.
• After pressing key combination for shortcut key click on Assign button.
• It will record you activity.
• Now after finishing your document go again on Macro option and stop the Macro.
• Now your document is recorded. You will be able to automatically perform the recorded task in a few seconds by pressing the shortcut key.