Developer Tab: Find the Tab that You Need for Macros, VBA and More

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

Step-by-Step:

  1. Use this solution to record macros or if you routinely access and edit workbooks that contain macros.
  2. Click the File tab.
  3. Click the Excel Options button.
  4. Click the Customize Ribbon button.Fred Pryor Seminars_Excel Macros VBA_Figure A
  5. Click the Developer check box  Fred Pryor Seminars_Excel Macros VBA_Figure B so it is checked in the Main Tabs box.
  6. Click the OK button. The Developer tab will now appear with your other tabs. Fred Pryor Seminars_Excel Macros VBA_Figure C

Fred Pryor Seminars_Excel Macros VBA_Figure 2

Fred Pryor Seminars_Excel Macros VBA_Figure 3

Fred Pryor Seminars_Excel Macros VBA_Figure 4

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

Microsoft® Excel®: Beyond the Basics

Related Advanced Excel Articles

Categories

Monthly Archives

Leave a Reply

Your email address will not be published. Required fields are marked *