I have a problem, my users are missing on selecting a dropdown while working on a website (Intranet). I was looking for a macro which is continuously running, when a browser is selected by the user and clicks on "Complete Task" the macro must prompt the user that the Dropdown was not selected and Stop from proceeding.

Note: Once the user has clicked on Complete Task > Another popup window comes up > with Yes / No button

If the macro has prompted & stopped the user a secret email must trigger out to me "[email protected]"

Also, the users will be using multiple Excel file this macro must not interrupt the other files.

If this can be done as a VBS script also, I will be very happy.

Please help!