CODEWITHSUNDEEP
excelvba
Hamihamidd
Hamihamidd

Reputation: 39

Showing notification popup in excel

Is there a way to show a notification popup to users every 5 minute in excel through VBA or anything else?all i want to do is showing a message(reminder) automatically to users to save their works every 5 min.

Upvotes: 0

Views: 1932

Answers (1)

bzimor
bzimor

Reputation: 1628

Use this:

Sub my_Procedure()
    MsgBox "Save your workbook!"
    Call test ' for starting timer again
End Sub

Sub test()
    Application.OnTime Now + TimeValue("00:05:00"), "my_Procedure"
End Sub

To automate this macro, put this code into ThisWorkbook:

Private Sub Workbook_Open()
   Call my_Procedure
End Sub

Instructions here

!!! Be careful about automatization, just put some if condition to run popup code, otherwise this code may run decpite you close shared workbook.

Upvotes: 1

Related Questions