in MS Excel 2007, accross the top you have "Home" "Insert"....go to the far right tab that should say "Developer".

Then click "Macro Security" You can then add a Trusted Publisher who is the author of the macro or simply allow all macros in the macro setting Login to read more.