Monday, February 27, 2012

Enabling Developer Tab in Office

As an SharePoint dev I very seldom need/get to work with office, but I recently had the opportunity to do some VBA enhancements to one of the Contoso PowerPoint presentations and I discovered this powerful hidden tab that I am sure everyone in the know already knows about, as this is also available for Word, Excel, PowerPoint and Outlook I can see how this would be tremendously helpful to super users that enjoy fiddling and enhancing their office productions with only limited dev knowledge.

To display the Developer ribbon tab for Microsoft Office 2010 applications
  1. Start the desired application.
  2. Click File.
  3. Then Options.
  4. In the 'categories pane', click Customize Ribbon.
  5. In the main tab, tick the Developer tickbox.
  6. Then Click OK to close the Options dialog box. 
Now you'll see a new ribbon tab called 'Developer' and depending what you are working in you’ll see a variety of new button groups.

Word example:



 For more information on this and adding it to 2007 Word, Excel, PowerPoint and Outlook see: http://msdn.microsoft.com/en-us/library/bb608625.aspx

No comments:

Post a Comment