How to check for time and if ok to run?

[ibcarolek]

I have an application which users are not supposed to use between 5pm and midnight due to production jobs running and changing data. Does anyone have a code snippet which shows how to check a PC's time to determine whether or not a macro is runnable? That is, if it is between 5pm and midnight, all macros in the application should "fail" when called and if it's before 5pm, they work. Thanks for your help,

 

[gauntletxg]

perhaps

If Format(Now, "hh:mm:ss") > "15:00:00" And Format(Now, "hh:mm:ss") < "24:00:00" Then
    ' don't do anything
    Exit Sub
End If
' Your code here

 

[ibcarolek]

This works! thanks so much for helping out,
ck