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
- Start the desired application.
- Click File.
- Then Options.
- In the 'categories pane', click Customize Ribbon.
- In the main tab, tick the Developer tickbox.
- 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
If ever you manage to lose your sheets tab bar at the bottom of your excel workbook, don’t stress this is NOT some form of black magic, odds are its just hidden.
STEP #1 Stop the panic attack!
Most of the time if not 99%(this is a made up figure) of the time your workbook inside excel is most likely just not maximized and therefore you cannot scroll down to the bottom of the workbook.
The easiest fix for this is selecting the workbook you want/need as there might be multiple open once in the same instance of your open excel application and hit the maximize button, for Microsoft Excel 2010 the shortcut key is 'Ctrl' + 'F10' & poof just like magic its back ;)
If however it’s still missing, check your options to see if this bar is set to 'visible' to do this in Microsoft Excel 2010 follow these steps.
- Click 'File' > 'Options'
- In the Excel Options window select the 'Advanced' tab and scroll down to the display section, check that the 'Show sheet tabs' is ticked.
The last thing that it could be is that you’re not supposed to see them and its hidden using a VBA macro of some sort or it is password protected and you chose to ignore the popup prompting you for it or you don’t have the password allowing you to edit the data sheets.
Practice:
Robert Martin - The Clean Coder A Code of Conduct for Professional Programmers
"All professionals practice their art by engaging in skill-sharpening exercises.
Musicians rehearse scales. Football players run through tires. Doctors practice
sutures and surgical techniques. Lawyers practice arguments. Soldiers rehearse
missions. When performance matters, professionals practice.”
"In one way or another, all professionals practice. They do this because they
care about doing the best job they possibly can. What’s more, they practice on
their own time because they realize that it is their responsibility—and not their
employer’s—to keep their skills sharp. Practicing is what you do when you aren’t
getting paid. You do it so that you will be paid, and paid well."
