Want to modify the Macro to perform additional task

[JJFletcher]

Hello Everyone,

I have a Macro that is set perfect that when the timer reaches five(5) minutes the User receives a popup message "Are you still working with this File? Yes/No

If the User interacts with the Workbook all is good and the User moves forward with the work or task at hand.

Here is the question... Can the code be modified so if the user DOES NOT interact with the popup message box by selecting Yes or No that the code will recognize no activity with the Popup and the file is closed.

Please Login or Register  to view this content.

Your thoughts appreciated!

Regards,

John

[sourabhg98]

This would wait for 15 seconds, you can change the duration as needed.

Please Login or Register  to view this content.

[JJFletcher]

sourabhg98

Outstanding... Works perfectly

Thanks So Much!!!!