Mac OS X
Q: Applescript Excel set color of tabs
Hi all,
I would like to know how to target the Sheet Tab object in Excel to set its color index.
For e.g. set color index of tab 'Sheet2' to 3 -- yellow
OS X El Capitan (10.11.4)
Posted on Aug 3, 2016 1:12 AM
by Bernard Harte,Solvedanswer
iPhone
Something like this:
set (color index of sheet tab of sheet "Sheet1" of workbook "Workbook1") to 6
(Note, on my machine at least, yellow is index 6)
I also noticed that the display colour doesn't seem to update dynamically. I had to click on the tab to see the change.
Posted on Aug 3, 2016 6:56 PM