Friday, January 20, 2012

How to Import Macros for Excel


1. Open the workbook with the macro you want to import in Excel. Press 'Alt' and 'F11' at the same time to open the built-in visual basic editor.
2. Navigate to the macro you want to move using the left navigation pane.
3. Click to highlight all the VBA code for the macro. Press 'Ctrl' and 'C' at the same time to copy the macro.
4. Open the workbook you want to import the macro to. Press 'Alt' and 'F11' at the same time to open the built in visual basic editor.
5. Double click 'ThisWorkbook' in the left navigation pane. Press 'Ctrl' and 'V' at the same time to paste the macro you copied earlier into the VBA code window of the new workbook. Your macro is now imported.

Blogger news