Automatic notifications of changes?
 

Is ther any method of receiving an automatic e-mail notification whenever a
spreadsheet is modified?

I am setting up an error logbook and would like to get an automatic
notification whenever anyone reports an incident.

thanks

Iriemon

Automatic notifications of changes?
 

Yes.

You could probably invoke an instance of the Worksheet_Change event (google
search for more info), and combine it with some of the coding from Ron's site:
http://www.rondebruin.nl/mail/folder3/smallmessage.htm

Note that what you are asking does require a basic level of understanding of
VBA/macros.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Iriemon" wrote:

Is ther any method of receiving an automatic e-mail notification whenever a
spreadsheet is modified?

I am setting up an error logbook and would like to get an automatic
notification whenever anyone reports an incident.

thanks

Iriemon