How to Enable Macros in Microsoft Excel 2007 step by step

‘Macro’ an inbuilt feature of Microsoft Office helps us to assign own commands to do repeated work quite easily. In fact, Macro is a series of commands and actions derived by users to perform specific tasks.
Anyone working in Excel environment have to do certain amount of repeated actions to finalize spreadsheet. Surely, repeated exercise takes vital time of users. Undoubtedly, consumed time can be saved through defining own sort of command by help of Macro. As an example, if you need to enter a long text in Cells; it could not be seen properly without applying Text Wraps. Therefore, repeated actions to apply Text Wraps demands until last editing. Such scenario could be avoided after applying Macro.
Big question is that how anybody could be able to use Macro and avoid repeated tasks ? Being able to run Macro requires to enable this feature first in programme and after then record own commands.
Now, point of talking shifting to How to enable Macro?
Act of enabling Macro in Excel 2007 is little different to previous version of MS Office Package. In earlier version it was laid in Tool Menu, but in MS Excel 2007 you won’t find any Menu.  So, what to do for enabling Macro ? Follow successive steps and be able to enable Macro in Excel 2007.

 
  • Open Excel 2007 and click on to Office Button, which displays extremely left of the screen
ms office button
  • Now, Click on to button showing Excel Options
excel option
  • Then select Trust Center
excel trust center
  • Click  on to Trust Center Settings
excel trust center setting
  • Now choose Macro Settings and put tick marks in front of Enable all macros and press OK to enable.
enable macro

Certain steps mentioned above are essential to enable Macro in Excel 2007. Now, I am going to discuss to reset Macro option in existing Ribbon of Excel 2007.  For this you will have to activate Developer Tab, which has option of Macro. Just take these point wise steps: –

  • Open Excel and after then click on to Office Button
  • Now click Excel Option, which stays bottom part of existing screen
  • Then after put tick mark against show developer tab in existing ribbon.

These steps enable Developer Tab, which also has Macro option, at the position of existing Ribbon (Menu Bar) .

Tagged with 
           

Leave a Reply

Your email address will not be published. Required fields are marked *