I also had to "tick" the "Trust access to the VBA project object model"in "Macro Security" on the "Developer" ribbon in Excel 2007