Regarding Excel Macros

I want to trap event Excel like save and save as. I am doing this using macros .
Now i want to make this macro as global so that it will be applicable to all excel files.