Tuesday, August 20, 2013

How to Unlock the Secrets of Microsoft Excel 2007 Macros


1. Open the Excel workbook that needs a new macro. Click the 'Microsoft Office' button at the top-left end of the window. Scroll to the bottom of the menu and click 'Excel Options.'
2. Navigate to the 'Popular' tab and click the 'Show Developer Tab in the Ribbon' box underneath the 'Top Options' heading. Choose 'OK.'
3. Click the 'Developer' tab at the top of the workbook. Click the 'Macro Security' button in the 'Code' heading.
4. Choose 'Enable all macros (not recommended, potentially dangerous code can run)' if you want all macros to be able to run automatically. Choose 'Disable all macros except digitally signed macros' if you only want macros from trusted sources to be able to run.
5. Select the 'Record Macro' icon in the 'Code' heading when you are ready to record your new macro. Type a name to identify the new macro in the text box and click 'OK.'
6. Perform whatever functions needs to be repeated by the macro, such as deleting or adding rows, changing font or background colors, centering text or summing together the values of cells. Click the 'Stop Recording' icon in the 'Code' heading to finish recording the new macro.
7. Click the 'Macros' button in the 'Code' heading. Click the name of the macro you created. Choose 'Run' to run the macro and perform the recorded operations or 'Delete' to delete the selected macro.

Blogger news