Over the years I have been developing Macros to be used by me in my day to day work. Here are the links to the files that I have prepared for the same.
Copy the PERSONAL.XLS to Documents and Settings>Your User Name>Application Data>Microsoft>Excel>XLSTART.
Please note that these folders have to be unhidden. You can do that from the folder options.
The PERSONAL. XLS will automatically open at when Excel is started.
{NUMBER_FILES}