Excel 2007-Macro

i ;presume 2007 is the same as 2003?
you can click on tools, macros and visual basic editor and look at your project explorer and under "Modules" you will see the macros you have saved?
these may either be saved under the spreadsheet you are working on, or maybe in the PERSONAL.xls item.
have a hunt around to see where you save them and also notice when you save a macro, where it is being saved to.