JPEckelman,
To add a macro to a workbook:- Save a copy of the Excel workbook you want to modify
- Always test macros in a copy so that the original is preserved in case the modifications don't go smoothly
- Open the copy of the Excel workbook you want to modify
- Use the keyboard shortcut ALT+F11 to open the Visual Basic Editor
- Insert -> Module
- Copy/Paste the code into that area
To run a macro in a workbook:- In Excel 2007, go to the View tab in the ribbon
- On the far right, click Macros
- Double-click the desired macro (I named this one InsertRows)
Hope that helps,
~tigeravatar
Bookmarks