Forum Discussion

yoyo00335's avatar
yoyo00335
Copper Contributor
Nov 12, 2023

VBA

i can't fine the developer tool in my Microsoft 365 for programming with VBA can you help me

developer
  • djclements's avatar
    djclements
    Bronze Contributor
    Nov 12, 2023

    yoyo00335 What platform are you using? Windows or macOS? The process is pretty much the same across all Apps (Word, Excel, etc.), but differs slightly between Windows or macOS.

     

    With Windows, go to File > Options > Customize Ribbon, then under Customize the Ribbon > Main Tabs, select the Developer check box and click OK.

     

    With macOS, on the App menu, select Preferences. Then select Ribbon and Toolbar > Customize the Ribbon > Main Tabs, check Developer and select Save.

     

    Source: https://support.microsoft.com/en-au/office/show-the-developer-tab-in-word-e356706f-1891-4bb8-8d72-f57a51146792 

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Nov 12, 2023

    yoyo00335 

    In Excel 365, the Developer tab, which houses a set of tools and features used for creating and running macros, adding controls, and writing VBA code, might not be visible by default. To enable it:

    1. Open Excel: Go to any Excel workbook or open a new one.
    2. Access Excel Options:
      • Click on the File tab in the ribbon.
      • Choose Options at the bottom of the left-hand panel.
    3. Display the Developer Tab:
      • In the Excel Options window, select Customize Ribbon on the left-hand side.
    4. Enable the Developer Tab:
      • On the right-hand side, you will see a list of main tabs.
      • Find and check the box for Developer. This will make the Developer tab visible in the ribbon.
    5. Click 'OK': After enabling the Developer tab, click OK to apply the changes.

    Once you have done this, the Developer tab should now appear in the Excel ribbon at the top of the screen. You can access various developer tools and features from there, such as Visual Basic, Macros, Controls, and Add-ins.

     

    If you can't find the Developer tab in Excel even after following the steps to enable it, there might be a few reasons for this:

    1. Not Part of Your License: Some versions of Excel or Microsoft 365 subscriptions might not include access to the Developer tab or VBA features. For instance, certain enterprise or education-specific versions might have restricted access.
    2. Administrative Restrictions: In some cases, your organization's IT policies or administrator settings might have disabled access to the Developer tab.
    3. Corrupted Installation or Issue: There might be a problem with your Excel installation causing the Developer tab to be missing. Reinstalling or repairing your Office installation might help.
    4. Different Excel Version: Depending on the version of Excel you're using, the location or availability of the Developer tab might differ.
    5. Reinstall or Repair Office: Try reinstalling or repairing your Office installation if you suspect there might be an issue with your Excel installation.

     

    Additionally, if you are using Excel online or the web version, the Developer tab is not available, as it is primarily for the desktop version of Excel. AI was partially deployed to support the text.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark as best response and Like it!

    This will help all forum participants.

Resources