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

LIVE ONLINE SEMINARS

May. 11

Central Time Zone

May. 13

Eastern Time Zone

May. 18

Central Time Zone

May. 20

Pacific Time Zone

May. 24

Eastern Time Zone

May. 26

Central Time Zone

Jun. 2

Central Time Zone

Jun. 8

Eastern Time Zone

Jun. 10

Central Time Zone

Jun. 14

Central Time Zone

Jun. 16

Pacific Time Zone

Jun. 22

Central Time Zone

Jun. 24

Eastern Time Zone

Jun. 28

Central Time Zone

Jul. 7

Eastern Time Zone

Jul. 8

Central Time Zone

Jul. 12

Central Time Zone

Jul. 14

Pacific Time Zone

Jul. 15

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 20

Pacific Time Zone

Jul. 21

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Central Time Zone

Aug. 4

Pacific Time Zone

Aug. 5

Central Time Zone

Aug. 9

Central Time Zone

Aug. 10

Eastern Time Zone

Aug. 11

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 19

Central Time Zone

Aug. 23

Central Time Zone

Aug. 25

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Central Time Zone

Aug. 31

Eastern Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

May. 12

Central Time Zone

May. 14

Eastern Time Zone

May. 19

Central Time Zone

May. 21

Pacific Time Zone

May. 25

Eastern Time Zone

May. 27

Central Time Zone

Jun. 3

Central Time Zone

Jun. 9

Eastern Time Zone

Jun. 11

Central Time Zone

Jun. 15

Central Time Zone

Jun. 17

Pacific Time Zone

Jun. 23

Central Time Zone

Jun. 25

Eastern Time Zone

Jun. 29

Central Time Zone

Jul. 8

Eastern Time Zone

Jul. 9

Central Time Zone

Jul. 13

Central Time Zone

Jul. 15

Pacific Time Zone

Jul. 16

Eastern Time Zone

Jul. 21

Eastern Time Zone

Jul. 21

Pacific Time Zone

Jul. 22

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Central Time Zone

Aug. 5

Pacific Time Zone

Aug. 6

Central Time Zone

Aug. 10

Central Time Zone

Aug. 11

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 18

Eastern Time Zone

Aug. 20

Central Time Zone

Aug. 24

Central Time Zone

Aug. 26

Central Time Zone

Aug. 27

Pacific Time Zone

Aug. 31

Central Time Zone

Sep. 1

Central Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

May. 14

Central Time Zone

May. 19

Eastern Time Zone

May. 25

Central Time Zone

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 17

Central Time Zone

Aug. 23

Central Time Zone

Sep. 1

Pacific Time Zone

Related Advanced Excel Articles

Leave a Reply

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