Developer Excel For Mac

  1. Developer Excel 2016 Mac

It only seems to happen on Excel for Mac 2016 and 2019. I know that starting with Excel for Mac 2016, Excel is “sandboxed”, meaning you cannot save files wherever you want via VBA code. But my code is written to save the file in a particular folder that should always be accessible by Excel, regardless of the sandbox limitation: /Users. The Developer Tab The Developer tab gives you quick access to some of the more advanced features and functions available in Excel. By default, the Developer tab is hidden, but unhiding it is quick and easy, and I’ve outlined the steps below. The great news is that you only have to follow these steps once.

This Excel tutorial explains how to display the developer tab in the toolbar in Excel 2010 (with screenshots and step-by-step instructions).

See solution in other versions of Excel:

Question: In Microsoft Excel 2010, how do I get the Developer tab to display in the toolbar at the top of the screen?

The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.


Answer: To display the Developer tab, click on the File menu and then select Options from the drop down menu.

When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.

Now you should see the Developer tab in the toolbar at the top of the screen. All of the Developer tab option groups should be available - Code, Add-Ins, Controls, XML, and Modify (see below).

Developer tab is one of the most important and highly useful options in Excel. But, before you use it you need add it on ribbon. When you install Excel, you need to activate it for first time.

So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well as in Excel 2011 for mac.

Quick Navigation

To enable it follow these simple steps.

  • Go to File Tab → Options → Customize Ribbon.
  • In the main tab list, tick mark check box for the developer.
  • Click OK.

Here is another method to display developer tab.

  • Right click on Excel ribbon and select customize ribbon.
  • In main tab list, tick mark check box for the developer.
  • Click OK.

After following any of the above methods you can activate developer tab in Excel for Windows.

Note: You can use both of the above methods in Windows version of Excel (2007, 2010, 2013 and 2016)

Here are the steps to add developer tab in Excel 2011 for Mac.

  • Go to Excel Menu → Preferences.
  • Click on Ribbon in 'Sharing & Privacy Group' and then Click OK.
  • Now, you will get a pop-up dialog box. In customization section, select Developer Tab & click OK.

After following any of the above methods you can activate developer tab in Excel 2011 for Mac.

What's Next

VBA is one of the Advanced Excel Skills, and if you are getting started with VBA, make sure to check out there (What is VBA and Excel Programming)

Developer Excel 2016 Mac

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.