SheetTabColor

Applies certain color to sheet tab in Excel.
ColorNumber is Excel ColorIndex.
Found a code in https://www.vbatricksntips.com and thought to put it here enhanced.
Edit 2024-12-16: Adding fix for activesheet of WB workbook

CodeFunctionName What is this?

Public

Tested

Imported

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Linkedin Login

Optional ColorNumber = 21, Optional Shee = "Active", Optional WB = "This"

Views 257

Downloads 119

CodeID
DB ID