For Excel 2003:
-
With a spec open in Excel, on the menu bar, select Tools > Protection > Unprotect sheet.
For Excel 2007 and Excel 2010:
With a spec open in Excel, select Office Button > Excel Options > Microsoft Office Excel Trust Center > Trust Center Settings > Macro Settings > Enable all macros.