#1
|
|||
|
|||
How to get color-code Non-Working time
Problem
I want to use vba code to read the color-code of the non-working time from the graphic screen. I found code to put it but don't know how to get the color code. Question What could be the vba-code? Example code Code:
Sub Timescale_NonWorking() ' Sets nonworking time behind the task bars to red. ' Activate Gantt Chart. ViewApply Name:="&Gantt Chart", ApplyTo:=0 TimescaleNonWorkingEx Draw:=pjBehind, Color:=&HAAAAFF End Sub |
#2
|
|||
|
|||
In Microsoft VBA, there is a Method for working with the Timescale object, but as far as I know, there is no Property for working with it. Sorry, but hope this helps.
|
#3
|
|||
|
|||
Thanks for thinking along.
I also found an answer similar like that. (Get color of the task bar in Microsoft Project (VBA) - Stack Overflow) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Color-code each letter according to his spreadsheet value | zhz | Word VBA | 4 | 02-09-2018 05:16 PM |
Field Code/Switch for Time not working | Ozzie2842 | Mail Merge | 1 | 12-20-2016 01:08 PM |
Add Time Code | ossosso | Word | 14 | 01-07-2016 05:10 AM |
Color code filenames in explorer | terence_laoshi | Office | 0 | 01-18-2011 11:01 PM |
Color code incoming emails | Shawn76 | Outlook | 0 | 05-22-2010 07:55 AM |