Hide or Show Worksheet Tabs in Excel

Option 1: Using advance option in the Microsoft Excel

File Menu à Options à Advanced à Scroll down à Display options for this workbook: 

þ Show Sheet Tabs à to show sheet tabs

¨ Show Sheet Tabs à to hide all sheet tabs

Note: When you hide all sheet tabs you are unable to move to other sheets in the workbook. So you need to create links to other sheets before hiding all sheets.

Hide or Show Worksheet Tabs, Excel 2007, Excel 2010, Advanced Excel, 

Option 2: Using Visual Basic Application (VBA)

File Menu à Options à Customize Ribbon à Tick þ Developer à OK 

VBA

à Insert à Module à Double click on Module and then copy and paste code below.