D'Arcy from Winnipeg
Solution Architecture, Business & Entrepreneurship, Microsoft, and Adoption

Developer Tab in Excel 2007

Monday, March 12, 2007 10:48 AM

Where's my toolbox...where's that button that will let me put a control into an Excel spreadsheet...?

Right click up by Excel's menu (not the ribbon, but the menu with Home, Insert, Page Layout, etc.).

Select "Customize Quick Access Toolbar"

Go to Popular area in the form that shows up.

Check the box that says "Show Developer Tab in the Ribbon".

w00t

D




Feedback

# re: Developer Tab in Excel 2007

thanks m8 - really appreciated 4/20/2007 12:54 AM | chris owen

# re: Developer Tab in Excel 2007

Thanks a million for this. Whew!!!!

9/20/2008 4:43 AM | Folu Owolabi

# re: Developer Tab in Excel 2007

thank you so much!! 3/6/2009 1:52 PM | Sam Morgan

# re: Developer Tab in Excel 2007

The above information was correct and served my purpose.

Thanks 4/14/2009 8:16 AM | Zia

# re: Developer Tab in Excel 2007

nice tip. thanks 6/11/2009 10:51 PM | Pankaj

# re: Developer Tab in Excel 2007

Thanks a lot 11/21/2009 11:52 AM | Pam

# re: Developer Tab in Excel 2007

Anyone know how to check to see if a menu is in the developer tab? In 2003 I had a workbook that could be used by a client or by a admin. Admins have an add-in that creates a menu (which is now in the developer tab) if the user was a client, the other tool bars would be turned off. I know how to code the ribbion off, but I would like to only do it if the menu is not present. 12/1/2009 6:26 AM | Chris

# re: Developer Tab in Excel 2007

there is a way which i used to find the last row of my sheet.....

Sheets("Sheet2").Select
ActiveCell.SpecialCells(xlLastCell).Select
MsgBox ActiveCell.Row

ActiveWorkbook.Save 12/18/2009 1:43 AM | viveksoni

# re: Developer Tab in Excel 2007

Anyone knows how to eanble the developer toolbar with a GPO? 3/12/2010 7:53 AM | Guest

# re: Developer Tab in Excel 2007

Thanks bro! 3/14/2010 8:14 AM | TheCrack

# re: Developer Tab in Excel 2007

Thanks, that was helpfull. 3/10/2011 2:08 PM | Roger Kuchenmeister

# re: Developer Tab in Excel 2007

Here's how to do the same thing in Excel 2010 - http://www.wiseowl.co.uk/blog/s138/developer-rbbon-excel-2010.htm - annoyingly, the procedure is different. 7/1/2011 2:55 AM | Andy Brown

# re: Developer Tab in Excel 2007

Thanks bro 7/23/2011 1:34 AM | Indis

# re: Developer Tab in Excel 2007

Thanks,it helped me a lot 7/24/2011 8:24 AM | Bhuvana

# re: Developer Tab in Excel 2007

Thank you 9/8/2011 11:50 PM | Anne

# re: Developer Tab in Excel 2007

cant find the control ribbbon in the format control after righ clicking on the scrollbar to format in the developer. sum 1 help me pls. 11/4/2011 5:22 PM | aj

# re: Developer Tab in Excel 2007

Thank you!!! You are a legend! 11/10/2011 5:25 AM | Genna

# Find the developer rab in Excel 2010 and 2007

Here is a description on how you can find the developer tab in Excel 2010:
http://www.lazerwire.com/2011/11/excel-vba-display-developer-toolbar-or.html 11/16/2011 9:10 AM | Ulf

# re: Developer Tab in Excel 2007

I have the developer tab but my "insert" button doesn't work. I'm trying to insert a drop down calendar. Anyone know why? 12/29/2011 9:23 AM | Deb

# re: Developer Tab in Excel 2007

thanks a lot! 2/3/2012 12:50 AM | Sam Ang

# re: Developer Tab in Excel 2007

Thanks!
Arigato gozaimasu!
Cảm ơn rất nhiều! 2/8/2012 8:08 PM | hoangqui

# re: Developer Tab in Excel 2007

Thanks a lot !! 3/3/2012 5:59 AM | Santosh Arisetty

# re: Developer Tab in Excel 2007

Thank you! Showed up right up on google search! 6/18/2012 7:42 AM | random

# re: Developer Tab in Excel 2007

Perfect - thank you! 6/19/2012 1:30 AM | DalaiLama

# re: Developer Tab in Excel 2007

nice tip sir
7/2/2012 4:48 PM | sathish

# re: Developer Tab in Excel 2007

Hi, if you want to know step by step procedure to enable developer tab, just follow this link.

https://www.youtube.com/watch?v=bRcb9WNhKC0

This has the video, which shows step by step procedure to enable developer tab. 10/21/2013 10:00 PM | VALLURI

# re: Developer Tab in Excel 2007

Hi, I m jayesh. I opened developer mode in excel 2007.I tried to worked on it. but I can not worked with it. Icon is appeared on the ribbon. but it was not working as well as visual basic icon also. please, help me
Tx. 5/19/2014 9:44 PM | jay

# re: Developer Tab in Excel 2007

Hi,
I tried following your directions on how to show developers tab but is not shown in list. Could you guide me more specific or maybe there is something I'm doing wrong 3/30/2015 12:02 PM | Harvey Hawkins

Post a comment