How to Show - Hide Status Sheet Tag Bar in Excel 2010 / 2007 ?

If you have lost your Status bar in Excel 2010 / 2007, it might be due to some macro or a option available in the Excel 2010 / 2007. You can show or even hide the status bar in Excel 2010 /  2007 via a option in build in the Excel and also via VBA trick. In Excel 2010, there is the in build option available for the users to show / hide the status bar in accordance to there need. Steps to Show - Hide Status Bar in Excel 2010 are as below :

Click on the File tab to open the Option and then go to the Advance tab in the vertical menu of the option. Drill down to find the option saying "Display options for this workbook"

Click / Un click on the option saying "show sheet tags to Show - Hide the Status bar in Excel 2010 / 2007. Hope this helps you Show - Hide Status Sheet Tab Bar in Excel 2007 / 2010.

You can Hide the Status Sheet Tag Bar in Excel via VBA Trick Also for that you need is the small piece of Code which goes like this..

Sub Hide_Tab_Bar()
'Hide the Workbook Tabs for the Current Active Sheet
ActiveWindow.DisplayWorkbookTabs = False
End Sub

Download the Above VBA Code Workbook

To activate the above code just Open Excel, Press Alt+F11 Copy the above code into a New module and Close the VBA and save a it and run the macro.. and What..

You don't have the Status Sheet Tag Bar Now... Hurry. Stay tuned for more routine info.. around you and me