Alert Message After Somthing Changed

[Freshman]

Dear experts,

I've a folder contains 30+ workbooks in a network. Each workbook is for one
department to fill in different kind of requests. From column A to E, they
need to fill in date, time, name, department and request details. I want an
alert message can prompt me if an user fill in a new request so that I do not
need to open each workbook from time to time to check if there is any new
request. It is something like an email, a message will prompt me if I have a
new message. What I think best is, a message can tell me which workbook has
something changed or the workbook icon can change color...etc. Is it
possible? If yes, please kindly advise how to do it.

Thanks in advance.

 

[Lee Li Fong]

You can try to request to send email to you automatically when the user save the file or close the file by adding BeforeSave or BeforeClose event to ThisWork to all 30+ workbooks as coding below for example.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean

ActiveWorkbook.SendMail
Recipients:="(e-mail address removed)
End Su

blog: http://smartusemicrosoftoffice.blogspot.com/