Ho to get notified by getting mail when any changes done in excel

  • Thread starter Thread starter Deep
  • Start date Start date
D

Deep

I would like to get informed by getting mails to ma, if any of the values of
the cells are changed
 
You can send an email by th following method you could put this as a
selection change but you would end up with a lot of emails.
If you want to trigger it when a specific cell or range are changed you
could compare each cell in the range on each selection change.
My preference would be to send email as a save event.
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "Jimmy Page"
.Subject = "Changes to workbook"
.Body = "Changes have been made to workbook 1"
.Send
End With
On Error GoTo 0
Set OutMail = Nothing

Ron De Bruin has stacks of great stuff on email.
http://www.rondebruin.nl/mail/problems.htm
 
Back
Top