Thanks for trying, but no luck. Most of my coworkers have Excel 2003, which is what I'm trying to get this to work in. I saved it as an XLA, Excel tells me the xla file is open, but I can't see the macro's in the new spreadsheet in which I want to run it. Is all you have to do just put the macros in a blank spreadsheet and save it as an xla file (which is what I did)? Or is there some other step needed to make the macros show up in the other workbook. The xla spreadsheet is selected under ADDINS, so I can't figure out why I can't see the macros to run them.