Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary). The Developer tab is hidden away on most of the Office Suite's programs but in this post I will cover get it showing in Excel, PowerPoint, and Word. Right click anywhere on the ribbon, and then click Customize the Ribbon. The tab is turned off by default in Microsoft Office, but you can learn how to set it up in a breeze. I am assuming this is done because the majority of users do not use (learn to use) all the awesome stuff stored on the tab. The best way to access the VBA developer environment, is the so-called Developer tab. Microsoft has chosen to hide this Ribbon tab by default. Ability to insert Form and ActiveX controls (think drop downs, scroll bars, check boxes, etc.). Access to the VBE ( Visual Basic Editor).Today you will learn how to unlock some of Microsoft Office's more advanced tasks. Things like a fully loaded QAT (Quick Access Toolbar) and extraneous add-in tabs are dead giveaways a user is delving into some of the more advanced functionalities of Excel (this assumption can be applied to Word & PowerPoint also). You can typically spot an advanced Excel user from a normal one by looking at their ribbon.
0 Comments
Leave a Reply. |