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
AUTHOR
Philip Treacy
Co-Founder / Owner at My Online Training Hub
Systems Engineer with 30+ years working for companies like Credit Suisse and E.D.S. in roles as varied as Network & Server Support, Team Leader and Consultant Project Manager.
These days Philip does a lot of programming in VBA for Excel, as well as PHP, JavaScript and HTML/CSS for web development.
He's particularly keen on Power Query where he writes a lot of M code.
When not writing blog posts or programming for My Online Training Hub, Philip can be found answering questions on the Microsoft Power BI Community forums where he is a Super User.
Plz All Traning with Video Kindely
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)
Hi Debraj,
thanks for that alternative method. Handy to know how to do it via the Immediate Window too.
Phil
thank you ,that right
You’re welcome 🙂
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
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