Micromanaging Macro Movement
As firms have been migrating from Office2003 to Office2007, the queston of what to do about the macros comes up. This is especially true as the limitation of rows was addressed by adding more character headings to the columns, which might have also been a name range before.
To solve this, a company called convertertechnology has a tool which inspects Macros, understands the versions, fixes them, and documents the changes..take a look here:
http://www.convertertechnology.com/