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
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.
[ This Message was edited by: Tom Morales on 2002-07-26 11:29 ]