Closed ijanderso closed 5 years ago
Fan of BIF.
Sure is! 🌔
Good news everyone
Sub TruHorizon™()
'
' TruHorizon™ Macro
' Rotate the BIFFUD Logo based on time of day
'
Dim i As Long
Dim time As Integer
Dim rotation As Long
time = Hour(Now) * 60 + Minute(Now)
rotation = time / 1440 * 360
For i = 1 To ActiveDocument.Shapes.Count
ActiveDocument.Shapes(i).rotation = rotation
Next i
Application.OnTime Now + TimeValue("00:00:10"), "TruHorizon™"
End Sub
I have mixed emotions about the fact that our letterhead is far more professional now, but, still, I do have to close this since WE HAVE A WEBSITE AND BRAND
okay, so we have a style guide in progress, but critically we want to be able to have the horizon for the logo change as a function of the time of day that the document is accessed/printed/etc. Is this possible?