Macro to prevent macros from running until certain time

[1nk3d]

Longtime lurker, usually can find what I need but this is bothering me.....

I have a report for work, that users pull data from. They click a button for the day of the week, and it pulls data from a report I upload, and gives them data for the previous day. However, many people are pulling it before I have the data (Usually 8:00). I want a macro to add in to my existing macro where if it is before 8:00, it will not allow them to run it.

 

[1nk3d]

I am not seeing where...?

I missed a parenthesis

 

[1nk3d]

I found it Long day! Appreciate the help

If (Now() - Int(Now()) < TimeValue("8:30:00")) Then

 

[1nk3d]

How would I work this to be before 8:30 or after lets say 17:00? And after 17:00 to display a different message....

I am getting "Compile error: syntax error when I use this code, the above one worked fine...

 

[1nk3d]

I quoted the wrong message.... Oops

 

[mikerickson]

Put 17:00:00 where my code has 8:30:00.
One branch of the If will call your code, and you can put a MsgBox in the other.

 

[1nk3d]

Would I place the second if after the else? So I’d really like it to be between 8:30 and 5. Anytime before or after should display a message

Put 17:00:00 where my code has 8:30:00.
One branch of the If will call your code, and you can put a MsgBox in the other.

 

[1nk3d]

Ok I got it! I used your code, and added a second line and added ElseIf with the after time.

Thank you