Developer tab was introduced in Excel
2007 and continued in later versions but by default it is not activated. This tab gives you more control over the
navigation to macros, add-ins, inserting various form or ActiveX controls, view
properties of sheets or XML. If you are serious about learning VBA and
stuff, enabling this tab will make your learning much easier. So let’s see how
to enable this tab.
In Excel 2010 or later
File tab > Options >
Customize Ribbon tab > Under Main
Tabs, check place a check mark next to Developer
> Click OK. (See below
picture)
In Excel 2007
Microsoft Office button > Excel
Options > Popular tab > Select Show Developer tab in the ribbon > Click OK.
That’s it. Now you can see a new
tab towards the right end named Developer.
Go on, click that tab and explore the options available.
No comments:
Post a Comment