Skip to search results
PRODUCT
Office.com results
Enable or disable macros in Office documents
Article Learn about macro security, the risks of enabling macros, and how the Trust Center in the 2007 Microsoft Office system can help to mitigate these risks.
Access 2007, Excel 2007...
Copy your macros to a Personal Macro Workbook
Article To reuse your macros, you need to copy them to a special workbook on your computer called a Personal Macro Workbook (personal.xlsb).
Excel 2010, Excel 2007
Copy a macro module to another workbook
Article Show All Hide All If a workbook contains a Visual Basic for Applications (VBA) macro that you would like to use elsewhere, you can copy the module that contains...
Excel 2007
Change macro security settings in Excel
Article Change the macro security settings to control which macros run when you open a workbook.
Excel 2007
Take shelter in Office with Crabby's tax-time tips
Article Crabby Office Lady This column is not devoted to how you can dodge tax time; no, my goal is to help you with the taxes you have this year and to get you organiz...
Excel 2007, Word 2007...
Copy a macro module to another workbook
Article To copy a macro in an Excel workbook to another open workbook, you use the Microsoft Visual Basic Editor.
Excel 2010, Excel 2007
Edit a macro
Article Before you edit a macro , you should be familiar with the Visual Basic Editor . The Visual Basic Editor can be used to write and edit a macro that is attached...
Excel 2007
Workbook contains a user form or class module
Article The workbook that you are opening contains a user form or class module in the VBA project that is associated with the workbook. This may be a security risk beca...
Excel 2007
Create or delete a macro
Article Macros can help you automate repetitive tasks and save time. You can use the macro recorder to record the macro or write your own macro script in VBA.
Excel 2007
Run a macro
Article In Excel 2007, after you record a macro, you need to run it to make it work. The Run button is in the Macro dialog box (Developer tab, Code group).
Excel 2007
Copy a macro module to another workbook
Article Copy a macro from one Excel file to another by using the Microsoft Visual Basic Editor.
Excel 2013
Create and save all your macros in a single workbook
Article Create and save all your macros in a single workbook by creating them in Personal.xlsb, a hidden workbook that opens every time you open Excel. Macros created i...
Excel 2013
Didn't find what you were looking for?Search all of Office.com