Change Worksheet Tab Colors

Sponsor

Excel Vba Question:

I’m using the following code to clear or change worksheet tab colors from a worksheet tab but unfortunately i am getting an error “Subscript out of range” error:
Sheets(”aaaDetail”).Range(”$A$1″).Select
Sheets(”aaaDetail”).Tab.ColorIndex = xlAutomatic

The first statement selects cell A1 is fine, but the second is errors.

Excel Vba Answer:

This excel vba change worksheet tab colors :

From

Sheets(”aaaDetail”).Tab.ColorIndex = xlAutomatic

To

Sheets(”aaaDetail”).Tab.ColorIndex = -4142

Rate This Tips:

Incoming excel search terms

excel vba change tab color,vba tab color,excel tab color formula,excel tab colorindex,excel vba tab color,excel vba worksheet tab color,worksheet color vba,vba worksheet tab,change tab color excel macro,color tabs in vba,excel change tab color based on cell value,excel default tab color vba,excel tab color based on cell value,excel vb change tab color,excel vb range from a different tab,excel vba add tab,excel vba clear tab color,excel vba tab color active sheet,excel vba tab colorindex=xlautomatic,how to put date in tab in excel,select coloured tabs excel vba macro,vb remove tab color,vba excel worksheet color,vba tab colorindex,1,activate tab color excel,add a tab color when selected using vba in excel,after sheet activate,assign colors to new worksheets vba,assigning colours in vba,change color excel vba,change color of a sheet based on another cell,change color of tab name in excel,change color of worksheet excel vba,change color vba,change default tab color in excel,change sheet tabs text in excel vba,change tab color according to sheet results excel,change tab color after sheet activate excel,change tab color based on cell,change tab color based on cell value,change tab color depending on cell value,change tab color depending on date in excel,change tab color excel vba,change tab color in excel based on cell,change tab color in excel vbs,change tab color with macro,change tab colour based on cell value,change tab to clear vba,change tab vba excel

Related Excel Tips

• Rename New Worksheet (0)
• Delete Worksheet (1)
• Copy from Worksheet (2)
• Clearing Data From Worksheet (1)
• Week Functions in Vba (0)
• Quick Way Determine The First and Last Business Day of the Month (1)
• Protect Range of Rows and Columns in Worksheet with Macro (1)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 30,441 views
  • Macro VBA to Remove Characters in String of Text - 20,680 views
  • Date Calculation Start Date Minus Year, Month and Days - 19,349 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 18,323 views
  • Insert Introduce Time Delay in Macro Vba - 14,310 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 14,214 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 13,952 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous