How to enable Record Macro function in Excel 2010?

Posted on

QUESTION :

After adding the Developers tab in Excel 2010, the Record Macro function became disabled.

How can I enable it again?

ANSWER :

Save as a Macro Enabled workbook.

1) Click the Office button and then click Save As.
The Save As dialog box appears.

2) Enter a name and select a location for your workbook.

3) Click the Save as Type drop-down arrow.
A list of file types appears.

4) Select Excel Macro-Enabled Workbook (*.xlsm).
Excel adds the .xlsm extension to the filename.

5) Click Save.

OR

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.

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.

Leave a Reply

Your email address will not be published.