I am trying to write a macro that will change the formatting for
colors and font upon opening a new excel workbook. [We are
implementing brand standards that may change in the future]

I've tried the Auto_Open() method and it doesn't work because it runs
the macro prior to a workbook being active.

Additionally, I want this macro to work properly if opening up an old
document.

Here is the outline of what I have so far: (sorry, never posted
before)

Sub Auto_Open()
Application.ScreenUpdating = False
Application.DisplayAlerts = False

ActiveWorkbook.Colors(53) = RGB(152, 0, 46)
ActiveWorkbook.Colors(52) = RGB(226, 126, 26)
ActiveWorkbook.Colors(51) = RGB(255, 192, 65)
ActiveWorkbook.Colors(49) = RGB(27, 117, 91)
ActiveWorkbook.Colors(11) = RGB(27, 44, 117)

Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

I'm guessing I'm not familiar with some command, but I typically use
ActiveWorkbook. Please help me out.

Thanks so much,
Sam