Does this sound familiar?
You open a workbook that contains macros and see a Security Alert message. You can’t find the Macro Dialog Box, and you can see that all VBA content is disabled by the default version of the program.
How familiar are you with the Developer tab?
If you frequently use workbooks and worksheets that include macros, or if you are an advanced user accustomed to utilizing advanced macro and VBA functions, you may find the default setting in Excel 2013 somewhat limiting. The Developer tab is where you will change these settings.
Microsoft Calls It: Enabling the Developer Tab, Enabling VBA, or Enabling Visual Basic for Applications
- Use this solution to record macros or if you routinely access and edit workbooks that contain macros.
- Click the File tab.
- Click the Excel Options button.
- Click the Customize Ribbon button.
- Click the Developer check box so it is checked in the Main Tabs box.
- Click the OK button. The Developer tab will now appear with your other tabs.