workbook.colors , what is used for?

[lezawang]

Hi
I wrote the code below but did nothing. What this code supposed to do? Thank you so much.

ActiveWorkbook.Colors(5) = RGB(255, 0, 0)

https://docs.microsoft.com/en-us/office/vba/api/Excel.Workbook.Colors

 

[dreid1011]

Looks like it changes the workbook's color theme either in whole or individual colors. In the case of that example and per the link you posted, it changes color 5 to red.

 

[Nine Zero]

This has to do with the 56 color palette that excel has

here is a link to look at the colors and their values http://dmcritchie.mvps.org/excel/colors.htm

what the code you pasted does it basically sets the color 5 (from the list of 56) to the color Red (255,0,0)