kluznic

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

Close

Q: Applescript Excel set color of tabs

  • All replies
  • Helpful answers

  • by Bernard Harte,Solvedanswer

    Bernard Harte Bernard Harte Aug 3, 2016 6:56 PM in response to kluznic
    Level 4 (3,309 points)
    iPhone
    Aug 3, 2016 6:56 PM in response to kluznic

    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.