Set Tab color.(Microsoft Excel Office Scripts)
Introduction to set Tab color using Office scripts.
The following syntax is used (Red text indicates variable parts)
// Set Tab color workbook.getWorksheet("Sheet name").setTabColor("Color code"); // Release Tab color workbook.getWorksheet("Sheet name").setTabColor("");
Color codes are specified in hex triplet (HEX). (Color picker)
To eliminate the heading color, specify a blank "".
For those who want to learn Office scripting effectively
The information on this site is now available in an easy-to-read e-book format for $3.00.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Scripts to streamline your workflow.