Notify me when updates take place

[JimD]

I have a workbook that I share with other employees is there any way for excel to notify me anytime this sheet is modified.

[Tom Morales]

Yes, but...

You can have a macro like this embedded in your spreadsheet:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim subber As String
subber = Application.UserName & " revised your spreadsheet"
ActiveWorkbook.SendMail Recipients:="your email address", Subject:=subber
End Sub

Any time someone saves the workbook, you would be sent a note. The "buts" are:

1. The user must have an e-mail program that Excel recognizes.
2. The user must have his Excel settings such that macro's aren't automatically disabled.
3. On Office 2000 and later, the user will get an alert that the spreadsheet is trying to send an email on his/her behalf, and is this something that they would care to permit. The user could squelch the email, then and there. So, user complicity is required.

Tom

_________________


[ This Message was edited by: Tom Morales on 2002-07-26 11:29 ]

[RichieRich]

You could send all the changes to a Log file (text file). That way, the user won't even know that the changes are being tracked.