Learn how to add the Developer tab to the ribbon in Excel for Microsoft 365 and Outlook for Microsoft 365. The Developer tab lets you write macros, use XML commands, ActiveX controls, form controls, and more.

On the Developer tab, in the Code group, click Macro Security. To enable the Developer tab, see Show the Developer tab . In the Macro Settings category, under Macro Settings , click the option that you want.

Si l’onglet Développeur n’est pas disponible, procédez comme suit pour l’afficher : Sélectionnez Préférences > Excel > barre d’outils & ruban. Sous Personnaliser le ruban, sélectionnez Onglets principaux, puis case activée Développeur. Cliquez sur Enregistrer , puis fermez Préférences Excel.

Step 1 - Ensure you're using the correct account. Make sure you're signed into your Microsoft 365 apps with an account that has a Copilot license. For home users ...this means you should have a Microsoft 365 Personal or Family subscription, and Copilot Pro.

Add or edit a macro for a control on a worksheet. Enable or disable macros in Office files. Enable or disable ActiveX settings in Office files. Create a Form button or a Command button and assign a macro that performs an action when a user clicks the button.

To edit a macro that is attached to a Microsoft Excel workbook, you use the Visual Basic Editor. Important: Before you can work with macros, you have to enable the Developer tab. For more information, see Show the Developer tab .

PowerPoint. Visio. Word. Learn how to get help for Visual Basic for Applications.

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab. Record a macro. There are a few helpful things you should know about macros: