do someone know if it's possible to execute a VBA code that send an email or windows notification when someone modifies, add a line for example or any modification. I want to use it for a file that help us to do regular check on the number of contracts delivered. So everytime someone types a new line, I can see it and put it on my own check file.

CodePudding user response：

The Worksheet.Change event is what you want. In short, whenever one of a certain type of change is made to the worksheet, this code is run. You can read more about it on the documentation page here:https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.change