place the code inside (Alt + F11) and paste This_Workbook
![]()
Private Sub workbook_activate() alertTime = Now + TimeValue("00:00:10") 'delay for open indtil execute macro closingTime = Now + TimeValue("00:00:15") 'delay fra open til close Application.OnTime alertTime, "EventMacro" If TimeSerial(6, 0, 0) < Now And TimeSerial(8, 0, 0) > Now Then Application.OnTime closingTime, "CloseMacro" End If End Sub
Bookmarks