Showing posts with label Change the Worksheet Tab Color. Show all posts
Showing posts with label Change the Worksheet Tab Color. Show all posts

Thursday, August 25, 2011

Change the Worksheet Tab Color

If you want to change the worksheet tab color. Snapshot below-



VBA Method-

Sub change_sheet_tab_color()
Sheets(1).Tab.Color = vbRed
Sheets(2).Tab.Color = vbYellow
Sheets("Sheet1").Tab.Color = RGB(137, 104, 205)
End Sub



Without VBA





Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...