After adding the Developers tab in Excel 2010, the Record Macro function became disabled.
How can I enable it again?
First click the File Menu(Office Backstage) and select Options from the left sidebar. In options, select Trust Center from the left sidebar and click Trust Center Settings button on the main window.
Now in Trust Center Settings dialog window, select Macro Settings from the left sidebar, choose Enable All Macros option and hit OK.
Save as a Macro Enabled workbook.
Change the settings of Digital Certificate for VBA Projects and Visiual Basic for Applications to Run from My Computer. Follow this on how to Install or remove individual Office programs and components.
Hope this helps.