I would like to make an Excel template with Standardized color options.
I have been looking and I have found some sort of VBA which changes the Color Palette using VBA
This should change the color right beside black to the color I desire, a specific blue.
Sub change_palette_color
dim color_index as long
color_index = 53
ActiveWorkbook.Colors(color_index) = RGB(22, 87, 136)
End sub
however after running this, the drop down menu for colors doesnt change. Is there a different way to change the default colors when you click the drop down menu for colors (ie. Home tab, Font, Fill Color drop down options)
I have been looking and I have found some sort of VBA which changes the Color Palette using VBA
This should change the color right beside black to the color I desire, a specific blue.
Sub change_palette_color
dim color_index as long
color_index = 53
ActiveWorkbook.Colors(color_index) = RGB(22, 87, 136)
End sub
however after running this, the drop down menu for colors doesnt change. Is there a different way to change the default colors when you click the drop down menu for colors (ie. Home tab, Font, Fill Color drop down options)