Office 2007 makes a complete overhaul of user interface from previous versions of Microsoft Office.
In Excel 2007,editing and viewing spreadsheet macros is now under a Developer tab group which is not enabled by default.
Here is how to enable the Developer tab which gives access to macros settings :
Open Excel 2007.
On top left,click on the Office button (yes that is a new shiny round button not present in previous Office versions)
Select Excel Options,in the Popular tab,check the Show Developer Tab in the ribbon option.
Once done,there will be a Developer tab in the main spreadsheet UI from where excel macros can be coded,viewed,tested and so on.
Cheers.