Notification possible?

[Dave]

Hiya

Once a month I build a spreadsheet which other users access until I do
the next one. There is a balance figure on the s/sheet which should
always be zero until I come to build the next s/sheet.

The other users should not do anything which will change the zero figure
- if they do, it means they've screwed something on my lovely s/sheet!

Is there any way I can set it so that if the figure changes from zero an
email (or some other alert/notification) is sent to me, so I can
immediately go and investigate the problem?

Thanks for any help!

 

[Jonathan Rynd]

Is there any way I can set it so that if the figure changes from zero an
email (or some other alert/notification) is sent to me, so I can
immediately go and investigate the problem?

Yes, using VB, you can set up macro that is run whever a Worksheet_Changed
event takes place, and in there you can check the value of the given cell
and if it's nonzero, send an email using MAPI.