In an opening workbook, the active sheet tab distinguishes from others by whitening the tab and bolding the text by default. If you want to make the active worksheet tab more outstanding in your workbook, a method in this article can help you.
Please do as follows to highlight the active sheet tab in an opening Excel workbook.
1. In the workbook, you want to highlight the active sheet tab, press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please double-click the ThisWorkbook in the left pane, and then copy and paste VBA code into the ThisWorkbook (Code) window. See screenshot:
VBA code: Highlight the active worksheet tab in an opening workbook
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim xSheet As Worksheet
Application.ScreenUpdating = False
For Each xSheet In ThisWorkbook.Worksheets
If xSheet.Name = ActiveSheet.Name Then
xSheet.Tab.ColorIndex = 6
xSheet.Tab.ColorIndex = 2
Application.ScreenUpdating = True
3. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.
Now, when you activate a sheet, the sheet tab is highlighted in yellow automatically as below screenshot shown:
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.