How to enable VBA Developer Tab in Excel

How to enable VBA Developer Tab in Excel

To use VBA code in Microsoft Excel the VBA Developer must be enabled. 

 

Before starting VBA coding, you must have Developer tab visible in your excel menubar. 

If you don't see then you can enable it from the ribbon.

Steps

Open your excel file.

1. Go to the File option. ( shortcut key: alt+t )

2. Click on customize Ribbon

3. Select all Tabs from choose commands from

4. Search for Developer

5. Add the developer in the right panel.

6. The developer is visible on the right side

7. Click OK.

Now the Developer tab will be visible in Excel Menubar

Thank You