Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
In the left pane, click Advanced. Select the Show add-in user interface errors.
Click OK.