Follow Us on Facebook

វចនានុក្រមខ្មែរ​
Khmer Dictionaries

Follow us on Twitter

Search More Information

Wednesday, March 5, 2014

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.

0 comments :

Post a Comment

Like Me on Facebook

Donation by PayPal

Thoinfo

Blog Archive