Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-02-2024, 02:57 AM
hansfrap hansfrap is offline How to get color-code Non-Working time Windows 11 How to get color-code Non-Working time Office 2021
Novice
How to get color-code Non-Working time
 
Join Date: Aug 2022
Posts: 11
hansfrap is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get color-code Non-Working time Color-code each letter according to his spreadsheet value zhz Word VBA 4 02-09-2018 05:16 PM
How to get color-code Non-Working time Field Code/Switch for Time not working Ozzie2842 Mail Merge 1 12-20-2016 01:08 PM
How to get color-code Non-Working time 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft