The Developer tab in Excel gives you access to features and tools that help you to write and run macros. It’s not enabled by default so this is what you do to get access to it.
Excel 2007
- Click the Microsoft Office button (the round button at top left)
- Click on Excel Options
- Click Popular
- Click on Show Developer tab in the Ribbon
- Click OK
Excel 2010 & 2013
- Click on the File tab
- Click Options (near the bottom of the list on the left hand side)
- Click Customise Ribbon
- Check Developer as shown here
- Click OK<
2010
2013
Please Share
If you liked this or know someone who could use it please click the buttons below to share it with your friends on LinkedIn, Google+, Facebook and Twitter.
muhammadjameel says
Plz All Traning with Video Kindely
Debraj says
You can choose this path also.. 🙂
* Open Excel.
* Go to VBA Editor (Alt + F11)
* Go to Immediate Window (Ctrl + G)
* Write below line
application.ShowDevTools = True
Exit VBA Editor. (Alt + F4)
Philip Treacy says
Hi Debraj,
thanks for that alternative method. Handy to know how to do it via the Immediate Window too.
Phil
manou says
thank you ,that right
Philip Treacy says
You’re welcome 🙂
Mani.C says
Dear madam / sir ,
i have three work sheet in different locations, a part from that i have a another work sheet in desktap (named that route wise sales) location so far i want to link up that three sheets to route wise sales sheet. with using of vlookup formula please help me
Catalin Bombea says
Hi Many,
Please provide a sample of you workbooks, with more details on what you intend to do, so it will be a lot easier for us to understand the problem and to give you the best solution.
You can use the Help Desk: https://www.myonlinetraininghub.com/helpdesk/
Cheers,
Catalin