VBA for Excel , message pop up at a time specified

Question

Hi,

Users are working with macros-enables Excel workbook.

Is there an opportunity to generate a VBA message at a specified time?
Example : Excel message pops up at 10pm CET and says "Please stop working and go home".

Thanks

Answer 1

Try executing a code like this:

Application.OnTime "22:00", "MyProcedure"

Also add a module containing this procedure:

Public Sub MyProcedure()

    MsgBox "Please stop working and go home"

End Sub

Probably the OnTime function can be called automatically from the Open event of workbook.