How to Transfer Excel Macros From 2000 to 2007

An Excel macro is a piece of executable Visual Basic for Applications (VBA) code that can help you to customize Excel. A macro can format a spreadsheet, create a graph, or perform calculations all at the push of a button. You don't need to know a programming language to build a macro: Excel's macro recorder builds the macro for you without you ever seeing a line of code. However, if you have macros built into Excel 2000 and you want to transfer them to Excel 2007, you'll need to locate and copy the VBA code over.

• 1

  Open the Visual Basic Editor (VBE) in Excel 2000 by pressing the "Alt" and "F11" keys together.

• 2

  Double click on the macro you want to copy in the left hand sidebar to open the code window.

• 3

  Highlight the code by left clicking at the top left of the code and then dragging the mouse to the bottom right.

• 4

  Press "Alt" and "C" together on your keyboard to copy the code to the Microsoft Office Clipboard.

• 5

  Close Excel 2000, then open Excel 2007.

• 6

  Press "Alt" and "F11" together on your keyboard to open the VBE.

• 7

  Click "Insert" and then click "Module" to open a blank code window.

• 8

  Press "Alt" and "V" on your keyboard together to paste the code into Excel 2007.