How to get color-code Non-Working time

hansfrap · #1 04-02-2024, 02:57 AM

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

DaleHowardMVP · #2 04-03-2024, 09:26 AM

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.

hansfrap · #3 04-04-2024, 03:13 AM

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