In this video I explain how to enable the Developer tab in Excel for Windows.

The Developer tab in the Excel Ribbon contains buttons for Macros & VBA. This includes buttons to open:
– The Visual Basic Editor (Alt+F11)
– The Macros Window (Alt+F8)
– The Macro Recorder (Alt,L,R)
– Macro Security
– Add-ins Menus
– Insert Form and ActiveX Worksheet Controls

The Developer tab is used frequently when creating & modifying VBA macros, and when adding interactive controls to the spreadsheet.

The Developer tab can be enabled in the Excel Options window. The easiest way to open Excel Options is to:
1. Right-click any ribbon tab and select “Customize the Ribbon…”
2. The Excel Options menu will open and the Customize Ribbon tab will automatically be selected in the left-side bar.
3. Click the Developer checkbox on the right listbox where all Ribbon Tabs are listed.
4. Press the OK button.

The Developer tab will be enabled and appear in the ribbon every time you open Excel. You only have to enable the Developer tab once time.

Nguồn: https://drslubitzandlamping.com

Xem thêm bài viết khác: https://drslubitzandlamping.com/cong-nghe/

39 COMMENTS

  1. Teacher Jon, good day to you. I have an error even though i have enable the developer but VBS and Macros are cannot clickable. It is fading.

  2. Hi. I can't add the Developer tab in my Ribbon. Even if I select it from Optiones->Customize Ribbon->and hit ok, it still does not apper…Don't know why..When I go back to Customize Ribbon it appears unchecked…Can you please help? Thank you.

  3. Which Excel did you install? Please tell me ? I have ms 2007 there is no developer option and file options . please help me

  4. Hi, I am not getting the option to right click on data to enable the developer tab … Please help me solving this .Thank you

  5. I'm sorry but this is a powerpoint question. in PPT 2019 THE DEVELOPER is not in the list. anyone can help? thank you!

  6. Hi….I have got the developer tab but in that Visual Basic and Macros button is disabled. How can I enable it.

  7. dear what if right click on ribbon is not showing THE OPTION CUSTOMIZE THE RIBBON 😳😲😢🤬😡😣😥😪 just fed up to access the add-ins options.

  8. EXCELLENT! THANK YOU! You speak VERY clearly, professionally, and you get right to the point. VERY impressive. You are the BEST!!!

LEAVE A REPLY

Please enter your comment!
Please enter your name here