Save time: Using macros in MS Office 2007

/, Office 2007/Save time: Using macros in MS Office 2007

Save time: Using macros in MS Office 2007

The new feature of ‘Macro’ introduced in the 2007 Office Suite by Microsoft can help users save enormous amounts of time wasted in trivial activities by following a simple procedure. Each time the user is about to perform a task that may need to be performed again; it can simply turn on the “Macro Recorder” before proceeding on with the implementation of the task. The task can now be performed as routine, meanwhile Microsoft Excel will create a series of commands and functions that correspond to all the movements, clicks and commands carried out during the particular task and store them in as workbook. Running the macro, later on will then automatically allow the functions and commands to be processed and carried out in the order that they were carried out before as they were in the recording run.

Next time when the user needs to perform the similar task, they can just refer back to the macro created and run it. The task is now automated fully and will be performed by Microsoft Excel, and thus will be executed at the processor speed, without any delays, disturbances or interruptions. Usually, the macro will take less than a second to perform a task that an individual may take more than 10 seconds to carry out. Macro also helps ease user’s workload by not requiring them to remember details regarding the formatting and other miscellaneous activities every time user need to carry it out. Every time the macro is run, it will provide with the same functions and results, as the manual task did. Macros can be created for carrying out the slightest of formatting to a whole range of other step by step tasks that may be required to perform on every document created or every workbook/ Excel sheet that is worked on.

Creating a new Macro in Microsoft Office 2007

To make use of this feature, following steps need to be taken by the user:

1) User should click on View and then on Macros button.
2) Then, he should click edit.
3) This will lead to the screen where the user may type in the code for the Macro he needs. The code for Excel Macros is in Visual Basic.
4) After typing the code, the user must debug it to check its error free, the user should click debug.
5) If there are no errors, the user should then test run the project by clicking Run.
6) He should then save the macro and assign a shortcut key, if required to the macro.
7) The user can now use the macro by simply pressing the shortcut key.

Running macros does not harm computer system in any way; however, one should be careful in selecting the macros that they want to run and not selecting all because that would also allow the harmful ones to run which they do not want. To get some information about macros and its uses please visit:



By |2018-04-19T19:55:49-05:00November 24th, 2012|Categories: Microsoft Excel, Office 2007|Tags: , |Comments Off on Save time: Using macros in MS Office 2007

About the Author: provides FREE computer training on products like Microsoft Windows, Microsoft Office, Microsoft Word 2013, Microsoft Excel 2013, Mozilla Firefox, Microsoft Powerpoint, Microsoft Access, Visual Basic, Internet Explorer, Java, SQL Server 2012, eBay, Windows XP and many more topics on IT training and computer learning.